How to create relationship between two tables?

[sunjin122]

Can anyone help me with this situation? As the screenshot shown below, how can i fix this problem and create a relationship between the two tables? Thanks ahead!

[Seth_C_Bauer · Accepted solution]

@sunjin122 The "one" side of the relationship needs to have only 1 unique value in the column you are using.

example: Relationship on Client between table "Many" and "One"

		Works
Many			One
Client	Product		Client
1	A		1	Name 1
1	A		2	Name 2
1	S		3	Name 3
2	S		4	Name 4
2	S		5	Name 5
		Will Not Work
Many			One
Client	Product		Client
1	A		1	Name 1
1	A		2	Name 2
1	S		3	Name 3
2	S		4	Name 4
2	S		4	Name 4

[sunjin122]

Thank u for your explanation

[KGrice]

From the error message, neither table has a column of unique values to create your relationship, at least not on the column you're using to relate them. What kind of tables are you trying to relate? I only ask because it does not always make sense to try to create this relationship. However, if you have a real need for a many-to-many relationship, this article gives an in-depth description of how to make this happen using a bridge table.

[jahida]

Need more context, what do the tables contain?

[sunjin122]

Thank you for your reply