In this chapter, we’ll see how to retrieve information from one table in order to insert it into another. In our example, we will modify the Orders table in order to retrieve the customer and insert the items.
If we haven't already done so, we'll create a customer to have data to display. This operation is not mandatory to link the tables, but only serves to see the result of our modification immediately.
Now that we have a customer and an item, we can start modifying the Orders table by creating a new field within it.
From Options, select the Fields page. Click Add, set the correct table (in this case the table of orders) and in Field Type choose the SubTable item. This field type allows you to select data from another table and automatically fill the fields of the current tab according to the matching rules. Remember that the data are not linked, but copied. If, for example, the customer's name is changed, this will not be automatically updated within their orders.