Primary Key Fields

Okay, maybe I missed that and THOUGHT I had added the index. Go add an Index on dr no as Indexed Yes(No Duplicates) and then it shouldn't do it any more.

MainID shouldn't be repeated.

MainID is an autonumber so it should not have the same thing in it at all.
(oh, but it can in the sub table - because it is actually the thing that links the dwg no).
 
i have done this but it says there are duplicates so it wont save it

the data i have already in the table is

MainID 2 DrwgNo 1
MainID 2 DrwgNo 2
MainID 2 DrwgNo 3

MainID1 DrwgNo1
MainID1 DrwgNo2
MainID1 DrwgNo3
 
hi Bob, does that mean i do need a multifield index created on the two fields

thanks
 

Users who are viewing this thread

Back
Top Bottom