Forum Discussion
Relationship issue
Hi gbarr12345
o answer your question, it's necessary to understand the logic behind what you're trying to do, as it’s not clear at this moment.
On a technical level, the tables appear to have the same structure, so it’s unclear why you’re not performing a union (combining them vertically with a classified column if they represent different actions). The many-to-many relationships that have been created are due to the lack of a unique key for each table. Technically, you could address this by creating a bridge table, but that’s only part of the solution, as it’s not clear what you’re trying to achieve logically.
More information about many-to-many and bridges tables is here :
https://www.youtube.com/watch?v=aPLaun-tTgQ
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi gbarr12345
o answer your question, it's necessary to understand the logic behind what you're trying to do, as it’s not clear at this moment.
On a technical level, the tables appear to have the same structure, so it’s unclear why you’re not performing a union (combining them vertically with a classified column if they represent different actions). The many-to-many relationships that have been created are due to the lack of a unique key for each table. Technically, you could address this by creating a bridge table, but that’s only part of the solution, as it’s not clear what you’re trying to achieve logically.
More information about many-to-many and bridges tables is here :
https://www.youtube.com/watch?v=aPLaun-tTgQ
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thanks very much for your help Rita! Much appreciated!
Happy to help☺️
