Add to Favourites Add to Favourites    Print this Article Print this Article

In edit/insert mode, how can I see a list of possible values for a field, based on some foreign table ?

You have to set up appropriate links between the tables, and also set up the "display field" in the foreign table. See FAQ 6.6 for an example. Then, if there are 200 values or less in the foreign table, a drop-down list of values will be available. You will see two lists of values, the first list containing the key and the display field, the second list containing the display field and the key. The reason for this is to be able to type the first letter of either the key or the display field.

For 200 values or more, a distinct window will appear, to browse foreign key values and choose one.

Was this answer helpful?

Also Read