I have a grid set up with a drop down for a column that list al available pay rates that can be used in the system. The where clause for the drop down will select all available items from a table to use unless they are used already. This way the user can not select (or setup) the same item twice. I also have set the "Column .NET object access" property to be read only when in edit mode like this: isReadOnly=true;[indoogrid:idvalue]>0

the problem is that when they go to edit the row (as they are allowed to change other fields in the row) the pay rate is missing because it is not seen in the dropdown list as it is already used. So even though the item is read only its not there either. Is there a way to set the where clause conditionaly based on the [indoogrid:idvalue]>0? or something similar?