Overview
A relationship in Access helps you combine data from two different tables. Each relationship consists of fields in two tables with corresponding data. For example, you might have a ProductID field in a Products table and in an OrderDetails table. Each record in the OrderDetails table has a ProductID that corresponds to a record in the Products table with the same ProductID.
When you use related tables in a query, the relationship lets Access determine which records from each table to combine in the result set. A relationship can also help prevent missing data, by keeping deleted data from getting out of synch, and this is called referential integrity.
Procedure
Instructions can be found here >>> Microsoft Access - Create Relationships with the Relationships Pane
If you need further assistance, please contact us.
IT Help Desk Contact info & Zoom Link/Meeting ID
In Person: Hardman & Jacobs Undergraduate Learning Center - Room 105
Phone: (575) 646-1840
Email: help@nmsu.edu
Zoom Link: https://nmsu.zoom.us/my/nmsuithelpdesk
Or meeting ID: nmsuithelpdesk
Zoom with us M-F 8am-5pm