Forum Discussion
How to create multiple relationships between two tables (on separate columns)
Hello, I'm working on a report with multiple tables and multiple relationships between the tables. Want to know if it's possible to realize the following scenario. Let's say there is a table ...
Hi,
If you do not want to append the 2 tables then do this:
- Remove the relationship between the 2 tables
- Create a Category table and build a relationship from the Category columns of both tables to the category column of the new table
- Create a Calendar table and build relationships as mentioned in point 2 above
Hope this helps.
Ashish_Mathur
Super User
Super UserHi,
If you do not want to append the 2 tables then do this:
- Remove the relationship between the 2 tables
- Create a Category table and build a relationship from the Category columns of both tables to the category column of the new table
- Create a Calendar table and build relationships as mentioned in point 2 above
Hope this helps.