Is it possible to have a dddw where multiple items can be picked?
Posted on 2008-11-11
Here's what I'm trying to do:
I have a datawindow with two fields: SITE and DESTINATION_ID . SITE is not tied to any values in a table, but DESTINATION_ID is tied to a DESTINATIONS table. It is possible for one site to be assigned to multiple destination ID's. Example:
Originally, I made a datawindow with each inserted row having a text box for the SITE and a dddw for the DESTINATION_ID. However, the customer says he would rather enter the site one time (i.e. WABC) and pick multiple destinations.
Is there a way to have a dddw where multiple items can be picked?
Is this clear what I'm asking?