When I insert a record with a foreign key relationship, how can I change the drop-down to show another foreign table column? By default, it shows the foreign table's primary key (an int) that isn't very descriptive. Can I force it to display another field (like a varchar field with description) from the same foreign table?
For example, if there are foreign table GenderID's of 1=Male and 2=Female, and the foreign key is Person.GenderID, how can I force the dropdown to read "Male" or "Female" instead of "1" or "2"?
example tables:
Gender GenderID GenderDescription 1 Male 2 Female Person PersonID GenderID 1 2 2 2 3 1
MySQL v5.1.41 tables InnoDB