Dropdown menu questions.
Is it possible to have the data from a drop down box come from two databases?
Ex: Say the one database is going to be the assignements. So that when a page is displayed in FMPI it will display what is in table1. Now you need to change the information in that display cell and the display cell is a dropdown type. SO you click on the arrow to open up the drop down, now you will see the data from table2. Once you select a piece of data from table2 that will now populate the proper cell in table1 so the next time when you open up table1 thru this display and assignements page it will display the last data that populated that cell.
So how easy is something like this?