Trying to use DD for what it's not intended for.
Based on this thread, I already know at least part of the answer to my question -
I have a customer table that includes the Customer Name, City and State. A Customer may have more than one location, and I want to user to easily choose the correct one. Unfortunately, in these instances there may be multiple records with the same customer name, but different locations.
I can't concatenate these fields for the list label because the drop down box would be too wide. I can't populate a text field as a child field using DD with the location information.
But, can I populate a second list menu with the location info from the record ID selected in the parent list, all getting their data from the same table?
I know I should create the link table according to how DD is meant to be used linking the Distinct customer name to all it's possible locations, but that's out of the scope of this project - and the customer table is very large and that would be time consuming.
Any ideas of how to make this work with or without DD? TIA!