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?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.