Stopping duplicate entries
Posted on 2004-04-05
Does anyone have the code I could use to stop a second user from completing a questionnaire for the same office. Let me break this down.
1. User in an office completes a form. There is a field for their office identity.
2. A second user from the same office who has also received a button to complete the form tries to complete the same form.
3. I know there is a way to setup a dbcolumn, or maybe dblookup and have the office identity field validate if a form has already been received for this office.
4. Lets the user know the form has already been recieved and closes them out of the form.
Thanks for the help in advance.