pull down from fk in table

[joeharth]

Hi I am trying to find examples online on how to do this. A screenshot would be nice. I am in the internal_table_manager.php page and I would like to configure my main-table form to show values of my other-table. The main-table has the field other-table-id in it. and the other-table has two fields other-table-id and other-table-value. So I would like to display the other-table-values in a pull down in the form for main-table. I am not sure what to put in the "Linked items table names:" or "Items table foreign key field names:" Please, Help.

 

[DebbieS]

Read the documentation or search the forums for "drop-down" or select_single. This has been answered more times than I can count.

 

[joeharth]

Not sure how i am going to use a select to enter a fk value and display a list of values related to that fk. Do I have to edit the code? or can this be done using the admin interface?
thanks.

 

[Anonymous User]

Hi.
You don't need to edit any code.
You have to use the admin interface for the child (or details) table, then select the appropriate field.
In the interface configurator you have to change 3 option:
1. Field type: select_single
2. Primary Key Field: <master field name>
3. Primary Key Table: <master table name>

Try and see if it works.

Michele