A basic demo of table references
Sometimes you want to combine data across different tables. In this example, we've got a table of people and a table of scheduled appointments. You pick a person from the person table when creating a new appointment. This means that the appointments table has a ref-type column pointing to the person table. This allows us to pull in the person's nickname and write it to the appointments sheet when creating a new appointment.
Also see: tablet mode & fullscreen mode
How we built this app
In our appointments sheet, we've got a column called Person. This column is a ref-type column whose referenced table is the Person table. Note that the values in the sheet are from the key column in the Person table. This is because each row in the Person table is uniquely identified by the key. Then, we can access column values from the Person table once a user has selected a particular person in the form. For example, we created a column called Nickname in the Appointment table that copies over the person's nickname. We did this using a de-reference expression like this: [Person].[Nickname].
This is a preview of the data sets used in the app.
This is a high-level model of both the data entities and the UI elements in the app.