Two different relationships between two tables

[cah2035]

Hi all,

I am trying to work through some confusion about relating two tables. My app has a storage component. There are three tables:

• 'Storage Units' are entities that contain spaces to be occupied (like a cabinet)
• 'Storage Slots' are the spaces within a particular unit that can be occupied
• 'Items' are things can occupy slots

However, a storage slot can also be occupied by another storage unit, so there are two relationships that exist. One storage unit contains many slots, and one slot can contain either a unit or an item. I am struggling with how to handle the "parent unit" - "child slot" - "child unit" dichotomy. Is a many-to-many relationship what I need, or do I need to different tables for units?

[WarrenBelz]

Hi @cah2035 ,

You have not stated your data source here, but "normalised" structures like you have do not always fit the purpose. In your circumstances, I would have one table for 'Storage Units' and 'Storage Slots' (you will have duplicate entries on the first item) and a second table for Items. Also, if you have a non-relational data source (like SharePoint), then you will have a lot of non-Delegable queries to contend with.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[cah2035]

Hi @WarrenBelz 

Sorry, I am using Dataverse (Dataverse for Teams) and so I have built these relationships directly.

[WarrenBelz]

Hi @cah2035 ,

I do not use Dataverse (or Teams), so cannot offer code here, but I still suggest you consider the other comments I made.