Table default value - expressions

[Guest]

I want to use the Iff function to enter a default value in a table (field 1),
the Iff will be conditional on the content of another field (field 2) in the
table. The "normal" data entry to the field 1 is a lookup table.
I have tried but it complains about both field 2 and the expression - I am
stuck!
Grateful for any suggestion or tell me if it impossible
Pete R

 

[Douglas J. Steele]

You can't for a table.

You should be able to do it for a form based on the table, which should be
all you need, since you should never be working directly with the tables
anyhow.