I’m struggling with a logic problem here and would really appreciate some insights.
I have a Spaces table that lists the shelf spaces I have in a store.
Each space is defined by its column number and a letter specifying its row. Each column is different so not every column has every letter.
Then I have a Brands table where I need to assigns these shelf spaces to different brands.
For the brands table I want to create a Linked Record or Dropdown that lists every space available. basically listing all the combinations from my Spaces table.
In this example the list would be like:
Is this achievable at all? What’s the best way to achieve this?