I've created a form with the "Create Email" button from a query that references 4 different tables. I want to use the form to gather information from the project coordinator regarding a contract they are responsible for. The field called "Vendor Name" which is in 2 tables is linked through a lookup list, which works if the contract is with an existing vendor in our database. The person filling out the form just selects the name from the list and updates the address if necessary. If it is a new vendor that is not in the database, and it is entered in the Vendor field on the form, it creates an error and the data won't upload. Is it possible to somehow create the option to enter a new vendor name and contact information in this email form and have it populate the database if it does not already exist in the DB?
Problem gathering data through a form with lookup lists
- Thread starter tlandis
- Start date
