boblarson
Smeghead
- Local time
- Today, 05:45
- Joined
- Jan 12, 2001
- Messages
- 32,059
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).