How to add a dropdown box containing data from another table

This topic is locked

How to add a dropdown box containing data from another table	3/7/2009 6:03:31 AM
PHPRunner General questions
M mrhappy author I have a table called people with a field called Nationality. I have a table called Nationality with a field called Nationality with a list of Nationalities. I want to have my "add page" display the Nationality field and give the user to select from a dropdown list derived from the Nationality table/nationality field and once selected have it add the Nationality to the Nationality field in the people table. I don't understand where or how and would appreciate any help. Thanks, Tim


A	alang 3/8/2009
	You do this using a lookup table. On Visual editor, open the field properties, Edit As tab, and select lookup wizard. There are examples of this in the documentation and tutorials.