Forum Discussion
initpro
9 years agoRegular Visitor
Copy relation from one table to another
Is there a way to copy the relations from one table to another table. I have a few filtered tables with the equal table structure and like to use the same dimension tables. thanks for your suppo...
BhaveshPatel
9 years agoSuper User
What do you meany by this? can you please elaborate and if possible post a data model.
- initpro9 years agoRegular Visitor
I have one table t1 which includes data from different section.
This table has a lot of relations to other tables.
My filtered table t2 based on t1 and should have the same relations to the other tables.
therefore I am asking for a convenient way to relate these tables
- BhaveshPatel9 years agoSuper User
You can use Autodetect feature for relationships to be automatically defined.
For more information, Please refer to this documentation from microsoft here.
Thanks & Regards,
Bhavesh
- initpro9 years agoRegular Visitor
thanks for the hint.
I know this feature but even I let to detect auto relation then also other relations are made with no sense.
It would be fine to autodetect relations onle from tables of my choice.