Link 2 tables in 1 Form

[Guest_imported]

How do I link Two tables in a form so when users input Key values, the Form will automatically retrieve information from 1 table
- User input names in the Form, Form will search through the main Database and display Address, zipcode, city...etc.
and Form also allows users to continue adding information to another table.

Name Address zipcode city -- in Main Database

Name firstAppointment lastAppointment --in second Database

Thanks in advance,

 

[Eradic8or]

I would create two forms based ono the tables, making sure that your relationships are set up properly. And then embed the second form inside the first form (subform). This way all corresponding data will be shown and the user can edit only related records.

Eradic8or