Forum Discussion
Load error - relationships
So am I unable to have multiple 'Session Types' with the same 'Fee' and then multiple 'Session Bookings' that lookup to each of those types? I have a session types table where the type name, fee and duration get stored. Then session bookings get made and the type is selected on the booking (lookup). I need to be able to have 2 session types with the same fee but a different duration. Is this not possible?
You need to use the appropriate relationship for your data. If there are multiple session types for a single booking, then you cannot have a 1-to-1 relationship between tables. You'd need a many-to-one or a many-to-many relationship. Any time a relationship has a 1 side, the values on that side must be unique.
I will have a go at these things but that data logic doesn't make much sense to me. Surely I would only use a many to many relationship if I needed to relate multiple session types to multiple session bookings? I just want to relate a single session type to multiple session bookings. This works well in my dataverse model-driven power app, so is it just Power Bi that works like this and requires the different relationship. I want to be able to keep my single form column lookup on my session bookings form in my app, so can I just create the many to many relationship in Power Bi and then will it work?
Thanks in advance
If it's one-to-many, then use a one-to-many relationship, not a one-to-one. A one-to-one relationship requires unique values on both sides.
