A Genero application can display a form that contains a master-detail relationship between two tables. The user can search for a row in the master table, and the corresponding rows in the detail table will also be displayed. The values in rows from both tables can be added, deleted, or modified.
The form must contain fields from both tables and the table relationships must be set.
-
Select and select these columns from the orders table: orderid, userid, orderdate,
totalprice and creditcard. The container for these fields can be a table (to display multiple rows).
Click Next, select a Table container, click
Finish and draw the container within the enlarged grid, under the
original.
This form design now contains fields from the master table, account, and a detail table, orders.
Figure 1. Form tab
-
Select the Records tab. Select the master table record and make sure the
active property is checked. Select and identify a column as the unique key, if not already
identified, as indicated with the key icon.
Figure 2. Master table record
- Do the same for the detail table record.
Figure 3. Detail table record
-
Set the relationship between the master and detail records. Right-click the foreign key field
in the detail table record (orders.userid, in our example), and select Add
Relation To. Drag the arrow to point to the primary key in the master table record
(account.userid).
Figure 4. Master-detail relationship
-
Build and execute the program.
Figure 5. The application executes