Pages

Friday, 30 March 2018

Creating A Lookup/Relationship Access 2013

A Web App allows you to create a lookup, which ties or relates data between tables. (The relationship concept is described in Section 4, “Creating a desktop database,” for a desktop database.) The Web App does not have a separate area for viewing relationships. You can view them for individual tables by selecting Modify Lookups in the Table Tools group on the Design tab. 

A Web App simplifies the design process by keeping you focused on creating lookups between tables. The terms relationship and lookup mean the same thing in a Web App, and in the popup window used to create the lookup, you will see options similar to those available for creating relationships in a desktop database.

Create A Lookup:

1. On a blank line in the Field Name column, type a name for the lookup. 
2. In the Data Type column, select the Lookup data type. 
3. Select the option to look up data from a table or query. 
4. Select the table from which you want to get a value. 
5. Select the field to display. 
6. Choose how the related records are managed. 
7. Click OK. 

TIP: The lower part of the Lookup Wizard screen displays the optional rules for defining a relationship between the tables. 
Create a lookup 

8. Click Save. 
9. Click View. 
10. When viewing the data, you can see the Autocomplete control displaying the lookup data. 
11. In the browser, you can type data into the new field that was automatically added to the List Details view. 

TIP: If you have not changed the design of any views associated with your table, the added field automatically displays in the updated List Details view and Datasheet view for the table.

No comments:

Post a Comment