I have two tables. To make it easier I use the states and capitals example.
Table 1: has three columns one for states, one for capitals an identifier
Table 2: the identifier from the table 1, plus name of a person plus other information.
Using a database join element (dropdown) I get the wanted result, just the second column from table one is missing.
e.g. John Doe lives in Oregon. How can I show "Salem" as the capital in list view from table 2? At the moment I have only John Doe and Oregon, but not the capital.
Thanks
Roger
Table 1: has three columns one for states, one for capitals an identifier
Table 2: the identifier from the table 1, plus name of a person plus other information.
Using a database join element (dropdown) I get the wanted result, just the second column from table one is missing.
e.g. John Doe lives in Oregon. How can I show "Salem" as the capital in list view from table 2? At the moment I have only John Doe and Oregon, but not the capital.
Thanks
Roger