As a follow up question, how can I go about finding out what table is associated with a given dropdown field?
For instance, the field "AssignedTo" in the table SalesOrder is a dropdown. The list contains several employee names. There is an accompanying field that Method creates called "AssignedTo_RecordID". When I select an employee and view the accompanying recordID, I can see that it is not the record ID that belongs to the employee in the Employee table, nor is it the recordID from the Entity table or the Contacts table nor any other table that I can find. There is no screen named "AssignedTo" so I am at a loss as to how to track down the table associated with this drop down.
I am writing apps that use the Method API and I need a way of identifying the foreign table that is associated with a dropdown so I can access the data from that table.
Thanks!
-Kevin