Home > Administrator Functions > Nesting Tables

Nesting Tables

Designer tables can be nested, meaning that multiple records from a child table can be "linked" to a single record in the parent table.  In this example, Work Orders will be the child table to Machines, the parent table, as there will be multiple Work Orders for one Machine.

1. Create the Machine table, and add the desired fields.
2. Create the WorkOrder table, and add the desired fields.
3. In the WorkOrder table, create a Lookup field.  The Lookup field will "link" to the Machine.  Click Next.
   
4. Select the look up Table (parent), and select the display field to identify the record.  Click Finish.
   
5. Create the screen for the child (Work Order) table. Add the newly created Lookup field, to link the record to the parent table.
   
6. Create the screen for the parent (Machines) table.  Under related Entities of Add Fields, add the child table.  It will contain (Field Name - Table Name)
   
   
   
7. Test the newly created tables and screens.  Open a Machine record, and add a new Work Order record.  The Work Order record will be connected to the Machine record, and identified by the Serial Number.
   

See also