Dynamic records (for the lack of a better term)

Hi Airtablelers!

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:

1A
1C
2A
2D
3C

Is this achievable at all? What’s the best way to achieve this?

Thank you so much!

Isn’t this possible at all?
What would be the closest I can get?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.