Forum Discussion
several relations between two tables
A relationship can only be created between single columns, so if you need a relationship on multiple columns, then you need a combined column or index to match on. This isn't often a great idea though.
A better solution is to create a proper star schema with dimension table(s) for these columns.
A relationship can only be created between single columns, so if you need a relationship on multiple columns, then you need a combined column or index to match on. This isn't often a great idea though.
A better solution is to create a proper star schema with dimension table(s) for these columns.
thank you !!
i find that create a new column with a combination of two name in each table, was for me the easier and faster solution. it works well, because i need so a single relationship on this "index false name filter".
i will examine the star schema when i will have time 😉