Trigger script to omit records from table

[Spidey]

Hi,

Is it possible to trigger script to omit records inside the drop down menu. The data are from the a value list of property. I only like to omit records that are single residence from the property table. Thanks.

Spidey

[bcooney]

Create a calc field, result number, that equals the property ID if the property is a single residence. For example,

_kP_ID_single = if ( flag_IsSingle =1; _kP_ID ; "")

Create a value list that uses this new field.