Detete Duplicates

[KevinJ]

i want to replace data in table "a" with updated data from table "b". Both
tables have a field "F_ID". i would like to replace the "F_ID"'s in table "a"
with those from table "b". how can i do this?

 

[Michael J. Strickland]

First back up both tables.

For table B, go into Design Mode and set the F_ID field to primary key.

Then copy all records from table A into table B. Table A records with F_ID
same
as that of table B will not be copied and will be placed in an error table.

Now table B should contain what you want.

After you have verified table B contains what you want, delete table A and
rename table
B to table A.

 

[KevinJ]

Thanks a bunch, that worked fine

First back up both tables.

For table B, go into Design Mode and set the F_ID field to primary key.

Then copy all records from table A into table B. Table A records with F_ID
same
as that of table B will not be copied and will be placed in an error table.

Now table B should contain what you want.

After you have verified table B contains what you want, delete table A and
rename table
B to table A.

--