InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Solve : Prevent duplication? |
|
Answer» In an Access database, I have a subform attached to a main form linked by the Service ID. There is a combo box on the subform where the user can select names of adults who received a specific service (the bound column in the combo box is the ADULT ID). Jane Smith, for EXAMPLE, could be chosen more than once PROVIDED that the Service IDs are different. The user shouldn’t be able to enter her name TWICE under the same Service ID. Right now, the user is able to do that. How do I prevent that? |
|