lookup table current field.
I have a look up table in the following format:
1, "Item 1", yes
2, "Item 2", yes
3, "Item 3", no
4, "Item 4", yes
Code is obviously the bound column, Desc is what is displayed and current indicates it is currently valid option.
I want to be able to limit my list to display only item's 1,2 and 4 (this bit is easy). However if i load a record which has had 3 selected in the past, I want display item 3, even tho it isn't in the list. If a user wishes to change from item 3 they should see only the current options (1,2 & 4).