I have an order entry system on Access 2007 that currently has a field displayed for the customers email address (system will send a confirmation to that email address). The system has a customer table (contains all the information about the customer - loaded daily from QuickBooks), and an Orders table (it has many more but these are the two pertinent to this issue). The customer table has 4 customer email fields and we want to start using the other 3 (so far we have only used on per customer but we are getting requests to send confirmations to multiple people...).
Given that each customer record has 4 email fields, I am trying to add a drop down box on my order entry screen that displays all 4 field entries so the sales person can choose. The data on the entry screen is then written to the customer orders table (the email field chosen by the sales person will be written to the DB so we have a record of where the confirmation was sent). I cannot figure out how to make this work... I have tried unbound fields with a query, a lookup field in the table itself (not a good idea) and a bound field to email address #1 with a query... None come close. Can someone help me please...