---
title: "Explain About Relationships And Look Up Fields in MS-Access?"  
description: "Explain About Relationships And Look Up Fields in MS-Access?"  
author: "Sanjay Goenka"  
published: 2022-03-31  
canonical: https://answers.mindstick.com/qa/96632/explain-about-relationships-and-look-up-fields-in-ms-access  
category: "troubleshooting"  
tags: ["troubleshooting", "ms-access"]  
reading_time: 2 minutes  

---

# Explain About Relationships And Look Up Fields in MS-Access?

[Explain](https://yourviews.mindstick.com/view/86025/content-created-for-humans-not-for-bots-explain-this-statement) About [Relationships](https://yourviews.mindstick.com/view/82648/the-importance-of-unimportant-relationships) And Look Up [Fields](https://www.mindstick.com/forum/159126/sql-query-for-all-tables-and-fields-in-an-oracle-db) in MS-Access?

## Answers

### Answer by Hitesh Vohra

- The Lookup Wizard establishes a table-to-table link. It generates a foreign key that points to another's primary key.
- Using a **lookup field**, you can find ('look up') values in one table and utilise them in another. A lookup field can be used to supply values for a dropdown list and make data entry in a field easier. Let's imagine you want a list of the 50 states of the United States so your users can select one from the list rather than typing its name. Set up a lookup field for the state name in Access using the Lookup Wizard.
- In Access, a **relationship** allows you to merge data from two separate tables. Each connection is made up of fields from two tables that have the same data.
- The type of relationship that Microsoft Access produces is determined by the definition of the linked fields: If only one of the connected fields is a primary key or has a, a one-to-many relationship is formed. If both of the connected fields are primary keys or have unique indexes, a one-to-one connection is formed.

\

**Read More: [How You Can Import A Sharepoint List in MS-Access?](https://answers.mindstick.com/qa/96634/how-you-can-import-a-sharepoint-list-in-ms-access)**


---

Original Source: https://answers.mindstick.com/qa/96632/explain-about-relationships-and-look-up-fields-in-ms-access

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.