Discussion Locked

Access 2003 Table with Unique ID's

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have 2 Tables that I use for my form, TM which is the primary table and has a Primary key assigned to the field EXEID. I also have a table called Discussion which I have a field called DiscussionID that is an auto number. The Discussion table is a subform on the main form page. My problem is that it won't give the DiscussionID a unique number, it is using the EXEID as the number. When I tried to set the DiscussionID to no duplicates, I can only put in one record and the next one gives me an error. Any help would be greatly appreciated.

1 reply

by john.a.wills

In the properties of the parent form's invocation of the child form check the LinkChild Fields and Parent Child Fields under the Data tab.

This discussion is closed to new replies.