Access Data Type Lookup Wizard creating wrong relationship


I have two tables "Purchase Order Details" and "Parts". In the data type of the "Part No" column in the
"Parts" table I used the LookUp Wizard to look up "Part No" in the "Parts" table. This automatically created a
relationship between "Part No" in "Purchase Order Details" and "ID" in "Parts" as shown below.

If anything I want the relationship to be between "Part No" in both tables. How do I correct this?

Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
Dale FyeCommented:
Open the relationships window, find that relationship and delete it.

Then click on [Part No] in one of the tables and drag to the [Part No] column in the other table.
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Worked well. Thanks
Dale FyeCommented:
you're welcome
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.