2. PHPRunner General questions
  3. Using a dropdown for data entry - how ?
This topic is locked

Using a dropdown for data entry - how ?

 		7/26/2008 7:07:21 PM
PHPRunner General questions
F
 fulltilt author

Hi,
I'm very new to PHPRunner (just started using it yesterday), and I have this problem that I'm trying to solve :
My application uses a lot of lookup/dimension style tables, a simple example is that there is a Country table (that you can add records into), and a Business table that stores details of each Business. Entering a Country is all text fields, so that's easy but when I'm entering the Country field in the Business table I need to use a dropdown that shows the Countries available, and in the Business table I only store the primary key of the Country table
How do I do this ?
S
 		swanside 7/27/2008

Hi,

I'm very new to PHPRunner (just started using it yesterday), and I have this problem that I'm trying to solve :
My application uses a lot of lookup/dimension style tables, a simple example is that there is a Country table (that you can add records into), and a Business table that stores details of each Business. Entering a Country is all text fields, so that's easy but when I'm entering the Country field in the Business table I need to use a dropdown that shows the Countries available, and in the Business table I only store the primary key of the Country table
How do I do this ?


In the visual editor, double click on the field you need on the business table, and select look up table.
Select the Country table in the dropdown boxes.