Duplication check on tables. AutoNumber

[Lifeseeker]

Hi,

I have two master tables set up.

Right now in both tables, I have the PK set on a particular field(so the PKs are not the AutoNumber)

If I manually change the PK to be the AutoNumber for each of the two tables, is there any way to prevent adding the same records twice in each table?

I am assuming this can be done in a little VBA code? Some kind of duplication check?

Could someone guide me on how to go about implmenmenting this feature?

Much appreciated.

 

[Beetle]

If you just want to prevent duplicates in a table field you don't need any code, just set a unique index on the field (i.e. - select Yes-No Duplicates for the index). A field can have a unique index without being the PK.