Order
table and the latter - the Customers
table. Notice that the Customer ID
column in the Orders
table refers to the ID
in the Customers
table.Full name
and Country
columns from the Customers
table together with the Order Date
column from the Orders
table.Data source
- Jet tables
connection (referred to as External updates) and the Jet tables
- Interface
connection (referred to as Internal updates). The latter pair is syncing in real-time while the former one's syncing interval can be changed