Add a detail list to the form

Add a list to your form and create the master-detail relationship.

1. In the form, enlarge the grid around the master table to make room for the fields from the other table.
2. Select Container > Data Control. The Extend Form from Database dialog displays, showing the Column Selection page.
3. Select these columns from the orders table: orderid, userid, orderdate, totalprice and creditcard. Click Next >.
4. Select Table as the container. and click Finish. The cursor is set to allow you to place your container on the form.
5. Draw the container within the enlarged grid, under the existing fields. This form design now contains fields from the master table (account) and a detail table (orders).
   
   
   

   Figure 1. Form tab

6. 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

7. Do the same for the detail table record.
   
   
   

   Figure 3. Detail table record

8. 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

9. Select File > Save All to save the project and the modifications to its contents.
10. Build and execute the program.
    
    
    

    Figure 5. The application executes