Link 2 database

[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?

 

[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.

 

[ktfrubel]

Karl,
Thanks for the input, but these are two separate databases. Any help?

 

[KARL DEWEY]

Link one to the other. Get External Data - Link.
Then do what I posted.