I do invoices on behalf of many different people (managment company).
I have two databases set up
1. Contacts database with all the peoples information in it that I do invoices on their behalf such as postal address, ABN etc.
2. I have a second database called invoices with all the client information and invoice layouts etc in it.
I would like to be able to type a persons name in the invoice database and have it pull information into the invoice database from the contacts database.
Is this possible?