Forum Discussion
Solved
Use multiple relationships between 2 tables
Hi All,
I am trying to create multiple relationships between 2 tables, but it is not working.
| name | date | job |
| Ben | 2020.08.03 | job A |
| Ben | 2020.08.04 | job B |
| Fred | 2020.08.03 | job A |
| Fred | 2020.08.04 | job B |
| name | date | shift |
| Ben | 2020.08.03 | early |
| Ben | 2020.08.04 | late |
| Fred | 2020.08.03 | late |
| Fred | 2020.08.04 | early |
I need a multiple relationship between name / name and date / date to create the following table:
| job | date | shift | name |
| job A | 2020.08.03 | early | Ben |
| job A | 2020.08.03 | late | Fred |
| job B | 2020.08.04 | early | Fred |
| job B | 2020.08.04 | late | Ben |
I tried to use the m:n cardinalty relationship twice, but it is not possible. Do you have any ideas to solve my problem?
Thank you!
bbruegge , if it is imported then concatenated column and join
New column in both tables
key = [name] & "-" & [date]
2 Replies
bbruegge , if it is imported then concatenated column and join
New column in both tables
key = [name] & "-" & [date]
That solves my problem perfectly.
Thank you very very much for your help!
