I am working on a database with a pupil for choosing subjects in a technical college. Wanting to create a form to collect their subject Choices. The pupil table is connected to the choice table.
The form includes the tblChoice Subform
‘Before Update’ if a new subject is added to the table she needs the form to perform the following check. The choice order needs to be checked, 1 to 3 and these can’t be used twice.
Also upon adding a new record she needs the Primary Key ‘ChoiceID’ to increment by 1 for every new record.
I hope this makes sense and appreciate any replies
The form includes the tblChoice Subform
‘Before Update’ if a new subject is added to the table she needs the form to perform the following check. The choice order needs to be checked, 1 to 3 and these can’t be used twice.
Also upon adding a new record she needs the Primary Key ‘ChoiceID’ to increment by 1 for every new record.
I hope this makes sense and appreciate any replies