Forum Discussion
Relationships vs Matrix data
You should always avoid creating many to many relationship. this can be done by using bridge table.
check the video for better understanding
https://www.youtube.com/watch?v=LRzpJTliW8Q
https://www.youtube.com/watch?v=1L66tcLaRQ0
https://www.youtube.com/watch?v=aPLaun-tTgQ
and their should be only single active relationship between 2 tables.
You dont need to create relationship for each comparison. it wont solve your purpose.
I hope I answered your question!
You should always avoid creating many to many relationship. this can be done by using bridge table.
check the video for better understanding
https://www.youtube.com/watch?v=LRzpJTliW8Q
https://www.youtube.com/watch?v=1L66tcLaRQ0
https://www.youtube.com/watch?v=aPLaun-tTgQ
and their should be only single active relationship between 2 tables.
You dont need to create relationship for each comparison. it wont solve your purpose.
I hope I answered your question!