Thanks. That gives me what I was looking for.

Now I wonder (even after reading that George and Jim wrote) how come I don't get a VFP error when I do this:

INLIST(logically_deleted_yn,"Y","N",.null.)

?





>>I created a DBC and then stuck a table in it. Then I made a primary key and
>> some candidate keys. On all of the columns I am not allowing null values. In
>> the field-level rule of a column called logically_deleted_yn (not a candidate
>> or primary key), I have
>
>> logically_deleted_yn= ;
>> IIF(INLIST(logically_deleted_yn,"Y","N"),;
>> logically_deleted_yn,.NULL.)
>
>The field rule should return a logical value. If .F., then a field rule violation error (1582) will be thrown. Set the field rule to
>

INLIST(logically_deleted_yn,"Y","N")