I have been working on a questionaire database.
I need to prevent the user from saving a record that has already been saved.
The fields that cant be the same data at the same time are:
I put a a Primary Key on all three fields. But since it is a continuous form it will only allow one of the fields to append because of the continous record.
How do I set it to not accept duplicates on a continous form?