I am creating a simple database for an estate agency which basically consists of two main tables.
1. Purchasers
2. Vendors
I am trying to create a form which will auto-complete data from these two tables based on a single value (probably Name) and then output this data to a third table which would be "Sales", containing only the key details of each party, and also "new" details of the agreed sale which would be entered via this form (agreed sale price etc.).
Can anyone guide me on how to create this?
Thanks in advance!