How complicated it is to have a database do the following:
when a new contact record is being typed and a last name matches one that's already in the database a dialog box will pop up and read "last name matches another in database" "would you like to check others before saving this record.
then the already designed contact list can pop up so that the person can see if the contact really is in database. then let person go back to original form and continue entering info or exiting that record.
I tried talking them into using a unique field like phone number and the record just doesn't save if the number is duplicated, but boss wants to use last name.. and have a pop up of all the "smiths or jones" I would settle just to call up contact list and let him scroll. :)
thanks for your help, if there is some code and it isn't too much trouble could you highlight the lines or areas that I would have to input my table name or field names, I sometimes spend hours on missing changing the code in one line.
thanks again, I appreciate your help