I have a portion_type table.
I have 3 fields on a table that are FK's to portion_type.

I have these 3 fields on a grid as dropdowns.
The dropdown load code is
SELECT id,name FROM portion_type WHERE active=1

Now,
Lets say my person has a EntreeType set to Regular (ID #2).
If i set Regular Active=0, then it does not show up in the dropdown anymore. If i click the 'Add to List' option, it shows up as 2 (the ID [e.g the value in the person table]).
Ok, i get that - thats fine.

However, it is not what I need, I need to show 'Regular' in the dropdown and not '2'.

Is there something like this
SELECT id,name FROM portion_type WHERE (active=1 OR portion_type.id={EntreeType}) <<I need to use the field value to load. Is this possible?

Note: I do not want to use a lookup! (This will just have the selection display the id in the textbox).
Note: I do not want to use a lookup with fill in fields to fill a label