I have a need to set up a dropdown with relational linking between two databases. I have one table with an ID on it and another with ID and location. I need to be able to view the current location linked by ID and then click the dropdown to select a new location from the complete list of locations in the supporting table. I am using a SQL connector. What type of dropdown do I use? What properties do I set to allow normal display from one table and drop-down display from another?