I have 2 tables set up in a one to many relationship. Table 1 contains only one AutoNum field as UserID. Table 2 has 2 fields with UserID as Number and Datestamp as Date. (These are just simplified examples and the relationship between tables are set to cascade update and delete).
I created a main form with subform. The main form contains just the UserID and the subform contains the UserID and Datestamp.
All the browsing and scrolling between records are working fine, but when I tried to add a new user, the main form's UserID field displayed the literal 'AUTO NUM' and the cursor jumped to subform's Datestamp field. I entered a date and then Save the update. The problem is Table 1's UserID field has not been incremented yet therefore Table 2's UserId is set to zero.
What is the proper way to insert a new record in this scenerio.
Thanks.
I created a main form with subform. The main form contains just the UserID and the subform contains the UserID and Datestamp.
All the browsing and scrolling between records are working fine, but when I tried to add a new user, the main form's UserID field displayed the literal 'AUTO NUM' and the cursor jumped to subform's Datestamp field. I entered a date and then Save the update. The problem is Table 1's UserID field has not been incremented yet therefore Table 2's UserId is set to zero.
What is the proper way to insert a new record in this scenerio.
Thanks.