Link 2 database

K

ktfrubel

I have 2 database that I work in. I will call one OEM and the other NDA.
Every OEM agreement that is sent to a customer must also go out with an NDA.
However every NDA does not need an OEM agreement. Is there a way to link data
to the NDA database when an new OEM customer is entered into its database?
 
K

KARL DEWEY

I have 2 database that I work in.
Are these two databases or two tables in the same database?

If two tables then set up a one-to-many relationship with the NDA on the
many (You can have an NDA without OEM) and set referential integerity and
cascade update.
Use a form/subform NDA/OEM with Master/Child links set.
 
Top