How to select only a few rows of options in my reference table?

I have a reference table which has a list of rooms in a food production facility.

I have another table where the user needs to manage the temperature of products and will use the ref table to get the name of the fridges and freezers that he needs to record from.

But the ref table includes ambient temperature areas etc so I want to filter out the areas that are not applicable.

I created another column, “Type” in my ref table which assigns a value to each area and the ones I want in particular are the ones that are called “Cold Store”.

So I only want those cold store options to be accessible from my dropdown in my form. Is this possible?

Hi @Jaros

You may want to have a look there:

Even more, with a sample app:

…this question has been asked a lot on the community, I’m pretty sure you will find an answer among these posts:

Please see also (that may help you in writing expressions) :

Let us know if you have trouble at achieving your goal :slight_smile:

Cheers !