Creating Relationships within 2 different databases
Hello. How can I make information from database appear in a field on another database. For instance I want to type the customer name and then have their information (address, city, state, zip, and phone) appear in fields below. That way I am not typing the information in again.
I have a database created currently where my customers information is stored. I also have an invoice database. What I would like to do on the invoice database is have a field for customer name, enter their name, and then have the other information automatically appear.