S sbaud2003 Member Local time Today, 19:28 Joined Apr 5, 2020 Messages 184 May 2, 2020 #1 Is there any method to fire a Append query that will append duplicates
jdraw Super Moderator Staff member Local time Today, 09:58 Joined Jan 23, 2006 Messages 15,528 May 2, 2020 #2 Please provide more detail re duplicates. Every table in a relational database should have a primary key.
Please provide more detail re duplicates. Every table in a relational database should have a primary key.
Uncle Gizmo Nifty Access Guy Staff member Local time Today, 14:58 Joined Jul 9, 2003 Messages 17,396 May 2, 2020 #3 sbaud2003 said: Is there any method to fire a Append query that will append duplicates Click to expand... There is a discrepancy between your thread title and the question you provide. They say the opposite. Assuming your title is correct:- If you apply a unique index to the field or set of Fields that you do not want duplicated that will prevent duplicates being added...
sbaud2003 said: Is there any method to fire a Append query that will append duplicates Click to expand... There is a discrepancy between your thread title and the question you provide. They say the opposite. Assuming your title is correct:- If you apply a unique index to the field or set of Fields that you do not want duplicated that will prevent duplicates being added...