R
Randy
Access 2000. I have found instructions on how to delete duplicate records
by creating a copy of a table, changing the primary key and running an
append query. The problem is i need to assign at least 2 primary keys for
it to work for my db. Every field in my database (except the primary key)
can be duplicated and is duplicated in some instances. However 2 specific
fields (Weight) & (TagNumber) are never duplicated together in the same
record.. In other words, (weight) is commonly duplicated, (TagNumber) is
occasionally duplicated, but there is never an instance where these two
fields of the same record are duplicated. How do I have a primary assigned
twice...Thanks..Randy
by creating a copy of a table, changing the primary key and running an
append query. The problem is i need to assign at least 2 primary keys for
it to work for my db. Every field in my database (except the primary key)
can be duplicated and is duplicated in some instances. However 2 specific
fields (Weight) & (TagNumber) are never duplicated together in the same
record.. In other words, (weight) is commonly duplicated, (TagNumber) is
occasionally duplicated, but there is never an instance where these two
fields of the same record are duplicated. How do I have a primary assigned
twice...Thanks..Randy