Hi everyone
I have a table with the following fields: entry ID, surname, forename, date
I have created a form based on the table where data can be entered but I don't want people to be able to enter a combination of surname, forename and date that already exists in the table.
How can I create a validation that will flash up a message after the date text box has been updated warning the user to change the date if an entry with the same surname, forename and date entry already exists?
Thanks
James
I have a table with the following fields: entry ID, surname, forename, date
I have created a form based on the table where data can be entered but I don't want people to be able to enter a combination of surname, forename and date that already exists in the table.
How can I create a validation that will flash up a message after the date text box has been updated warning the user to change the date if an entry with the same surname, forename and date entry already exists?
Thanks
James