I have two related Tables .. (one to many relationship) .. table one has contact info, table 2 has remarks. I am trying to append a remark into table two using an append query. When I run the Append query it should put a remark into the Remarks table, using the related ID field. the problem is it does, but because the remarks table has multiple IDs (the many side of the relationship) for the same record it adds the remark multiple times ... and if there is no related ID (no previous remarks for that record) in the remarks table it does not append, in other words it doesn't create a new remark ID. any help will be appreciated. Thank You Kindly