by PhilB on Fri Jun 13, 2008 8:38 pm
Oink. I will give it a try.
EDIT:
So far it looks good except the DATE is recording the same as the SORTDATE in terms of formatting. It would be better to sort on SORTDATE but show the actual call date as a easy to read formatted field like 9:43 AM 6/10/08. The time of the call seems to be more important than the day according to the wife.
Another nice addition might be an index field so that each call gets assigned a CALLINDEX. This would make finding a number in the database easy. For example if the database was cleared, the next call would get #1. and increment from there until the database is cleared. The goal would be not to clear the database and keep a record of all calls. Then it would be easy to have a screen that displayed the image, number, name and CALLINDEX and reference that in the larger database. I guess this is useful if the database gets more than 1 page but I noticed that I have to nextpage for calls and have a hard time finding when they called.
I will keep you posted as I get more data to determine if the SORTDATE fix works over time.
Thanks,
PB