Two different relationships between two tables

(0) Share

Report

Posted on by CAH2035

193

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
CAH2035 193 on at

Like (0)

Report

Hi @WarrenBelz

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

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No