Defining subviews
If you want to show data from several tables and be able to update the data in more than one of the tables, you might need to use something more complex than a standard view. In Chapter 6, you learned how related items controls can display data from related tables on tabs. You can edit and add data to related tables from related items controls by opening views as pop-up views. Subviews can also help in this scenario. You can create a main view that displays a parent record’s information and embed in it a subview that displays all the related rows from a related table.
You can embed up to seven levels of subviews within another view (a view with a subview that also has a subview, and so on), although nesting more than two levels ...
Get Microsoft Access 2013 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.