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

Jaros
New Member

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?

0 1 541
1 REPLY 1
Top Labels in this Space