Pages

Monday, 2 April 2018

Designing With A Blank View Access 2013

A blank view will create a presentation that does not display any fields from the table. This can give you a greater amount of control over what data is displayed, although it might involve more work in creating the view. 
Normally, a view displays information from the table associated with the selected table and related tables, but you can add a view that displays information from an unrelated table. In this example, we will add to the Products table View Selector a view that allows you to browse through the Category records but not display any associated record from the Products table. 

Create a blank view:
  1. Locate the object in the Table Selector. 
  2. Click the plus sign. 
  3. Type a name for the view, select Blank as the view type, and then select the record source. 
  4. Click Add New View. 
  5. When the new view is displayed, click Edit. 
  6. Click the Data icon. 
  7. Change the record source. 
  8. Close the Data popup window. 
  9. In the Field List, select a field. 
  10. Drag the field onto the blank view. 
  11. After you have saved the changes, the View Selector for the table has a view that displays information from another table without involving the table associated with the selected table name caption in the View Selector.

No comments:

Post a Comment