Dynamic Value List
I have a Project database containing a project layout, and customer layout. When creating a new project within the project layout, I'd like to allow employees to create new customer records from the project record, including adding mulitple contact names and emails.
Once entered, the customer information within the customer layout would be accessible as employees created new projects, in that they would select the existing customer from a pop-up menu, and then select appropriate contact and email (filtered) for that customer.
This is a simple dynamic value list function, but I'm overthinking it and it's driving me mad...