Forum Discussion
jaryszek
Super User
Super UserHow to create bridge table with composite keys
Hi, i have found on web solution with bridge with 1 column. But what if my table should have more than 1 column as composite key? How to do this? Best, Jacek
jaryszekSuper User
Super UserOk,
in Access relationships would like like:
Form:
and in power BI i have something like here:
Should i use Bridge table in this case or just create relationships many to many instead?
What is a good practice in this case?
Best,
Jacek