Drop-down list with more than one item
Scenario: Table1: "pharmacies" related to
Question: How do I populate a drop-down list (in Rx) w/ values passed from more than one field of another table (pharmacies)?
Tried: Field/Control->Setup; Display as:->Drop-down list;
display values from-> Manage Value Lists->New;
Use values from field->Specify Field->Use values from 1st field
Problem: This approach seems to be limited to passing data from only one field of another table.