I have a Business Data Connectivity (BDC) functionality that is working properly. Each of my tables has a quick link that associates to their intended table in the database. When the user clicks on New Item the form pops up as expected, but I would like to include a drop down list of who should this item be associated with.
For example, I have a quick link of Phone Numbers when the user clicks the New Item button they can enter in the information, but so far they have to use the UserID (primary key from different table) to associate the data. They manually enter in the UserID number that they have to memorize from the User quick link.
Is it possible that I can modify the New Item form to include a drop down list of all UserIDs and have the user select who should this data be associated with? Rather than a number? Maybe query this information from my external database and put all the info into that drop down. Possible?
Someone please point me to some documentation that I can experiment with.