Multiple Selections write record for each selection
Posted on 2012-03-29
Our purchasing department wants a database created based on multiple vendor's contacts selected. I have created the form that they are requesting but I am not sure how to create a drop down list to select the vendors, then have the form list the contacts associated to the vendors selected. The purchaser than can select the contacts they want to email and have the form save each record in the database by vendor.
I know I can use a list box with multi select set to simple or extended and use duplicate record but how do I duplicate by the vendor selected.
Hopefully this makes sense.....
Attached sample would be great!!