compare data in two different database

L

Lavatress

I have an AUDIT.mdb database which has all the data that was added to my
other database called DataEntrymAIN2.mdb. When the user adds data to a field
called ID on the form, I want to be able to look up data in my AUDIT database
to make sure the ID is not being duplicated. Can this be done?
 
K

Klatuu

Link to the table in AUDIT.mdb that has the data you want to validate. It is
okay to link to multiple back ends.
 
Top