G goju Registered User. Local time Today, 22:06 Joined Apr 7, 2005 Messages 77 Jul 5, 2005 #1 pls can someone point me in the right direction have searched through the forums. i have two fields Forename & surename i need to prevent duplicate records if the forename and surename match another record.
pls can someone point me in the right direction have searched through the forums. i have two fields Forename & surename i need to prevent duplicate records if the forename and surename match another record.
maxmangion AWF VIP Local time Today, 22:06 Joined Feb 26, 2003 Messages 2,805 Jul 5, 2005 #2 why do you want to restrict your database so that no 2 people can have the same FullName ?
G goju Registered User. Local time Today, 22:06 Joined Apr 7, 2005 Messages 77 Jul 5, 2005 #3 sorry i dont i just want to stop a duplicate record if they both forename and surename match, and then have the option to add a duplicate if by chance two people do have the same name.
sorry i dont i just want to stop a duplicate record if they both forename and surename match, and then have the option to add a duplicate if by chance two people do have the same name.