Skip to main content ↑ ↓
Topic: lookup field (Read 1017 times) previous topic - next topic

lookup field

Suppose you have a data table 'customers'. Those customers have a property: nationality . To have users make similar choices, we can use a select with certain values as index and a description as text. I want to store an integer only, so not the text, in the customer table field nationality. I create another table: nationalities. There i store an ID and a descrpition. In the add and edit customer pages, i want the select filled with the index/value from the table nationality. In the other customer pages i want to see only the text, not the index.

EG both 'php generator for mysql'  and 'Code Charge Studio' have a standard field option called 'Lookup field'.

How can we do this in PHP Rad?

Re: lookup field

Reply #1 –
Why might the lookup field on a adding page to the table not work on another page is correct? The corresponding queries are the same.

Re: lookup field

Reply #3 –
When I create a lookup field, and I select an item in first field, in the second filed list iscorrect, but I
if I select an option in second list, the second list will empty. Why?