write the steps to add a look-up field in a table
Answers
Explanation:
1 Open the table in Design View.
2 In the first available empty row, click a cell in the Field Name column, and then type a field name for the lookup field.
3 Click in the Data Type column for that row, click the arrow and then, in the drop-down list, select Lookup Wizard.
Note The Lookup Wizard creates three types of lists depending on the choices you make in the wizard: a lookup field, a values list field, and a multivalued field.
Carefully follow these steps in the wizard:
On the first page, select I want the lookup field to get values from another table or query, and then click Next.
On the second page, select the table or query that contains the values, and then click Next.
On the third page, select one or more fields, and then click Next.
On the fourth page, select a sort order for the fields when displayed in a list, and then click Next.
On the fifth page, adjust the width of the column to make the values easier to read, and then click Next.
On the sixth page, keep the field name or enter a new one, select Enable Data Integrity, choose a Cascade Delete or Restrict Delete option, and then click Finish.
For more information about enforcing referential integrity, see Create, edit or delete a relationship.
Save your changes.