Hello everyone,
Trying to make/design a form for adding a persons Social Security Number. I have existing data within my database as a table. I can get everything to work properly with a form for adding new data except for this particular field. The data and where it originates from constantly changes but it does not drop off existing data. I guess the problem is that I obviously cannot have a duplicate entry.
So I want to be able to have my data entry persons add the students via this form but like I said I cant have duplicate entries. Ideally I want to have the SSN field at the top so that when a new record is about to be entered and the ssn is already in the database that it pulls up the record already in existence? Someone point me in the right direction?