Forum Discussion
Solved
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
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: