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?