Forum Discussion
How to create relationship between two tables?
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!
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
5 Replies
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.
Need more context, what do the tables contain?
Thank you for your reply
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 Thank u for your explanation:smileyhappy:
