Views
Views are virtual tables. They can be created by filtering a single table and/or by combining related data from more than one table. Views are considered virtual tables because they don’t actually hold any data. The data you see in views is pulled directly from existing table data. The view data is recollected dynamically whenever the view is referenced.
Views can be used just like tables as the source of your DataPages, or as an authentication table. When creating a view you can indicate one of the contributing tables as editable. Views with at least one editable table can be used as the source for DataPages that receive or edit data.
Individual tables are combined in views by using keys. Keys are reference values that tie two records together. For example, if one table has an AutoNumber field used as a Record ID (Key Value), the records in a second table can use a Number field to keep a reference to that outside ID (Foreign Key).