Trace:
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision Last revision Both sides next revision | ||
|
jvx:client:model:databook:master_detail [2018/02/01 08:19] admin created |
jvx:client:model:databook:master_detail [2018/02/01 10:57] admin |
||
|---|---|---|---|
| Line 166: | Line 166: | ||
| rdbStates, new String[] {"ID"})); | rdbStates, new String[] {"ID"})); | ||
| </file> | </file> | ||
| - | |||
| - | hergestellt. | ||
| The master/detail relationship between countries and states is created via the foreign key (STATES.CTRY_ID) to the primary key (COUNTRIES.ID). This means that when a country is selected, all associated states are displayed. States that are not assigned to the selected “master” country are not shown. | The master/detail relationship between countries and states is created via the foreign key (STATES.CTRY_ID) to the primary key (COUNTRIES.ID). This means that when a country is selected, all associated states are displayed. States that are not assigned to the selected “master” country are not shown. | ||
| Line 177: | Line 175: | ||
| When a new district is entered, the correct state is used. The district is therefore automatically assigned to the correct state. | When a new district is entered, the correct state is used. The district is therefore automatically assigned to the correct state. | ||
| + | \\ | ||
| **<fs 20px>Note</fs>** | **<fs 20px>Note</fs>** | ||
| A master/detail relationship does NOT require that a foreign key relationship exists between two tables. Any columns can be used. | A master/detail relationship does NOT require that a foreign key relationship exists between two tables. Any columns can be used. | ||