Hello,
I have setup two tables with a one to many relationship. The ID number one the parent table matches many of the "Connection ID" field I created. After appending a record to the first table, it has an ID of "1" let's say. Next I run another append query for the child table where I am trying to populate the "Connection ID" column with the ID that matches.
If I take the ID field out of the append, it will accept the records, but otherwise says there are "key violations". However the field I am appending to is not setup as an index. The only thing different about it is that it is identified in the relationship as needing to match the parent ID.
What am I doing wrong? Thanks for your help!