Michael L. Horne schrieb:

> That would be fine, but how do I do it. This field is being
> pulled from another file based on a field in this record, but
> the second field doesn't have to contain a key. So how do I
> write the SQL to make this value default to "F" if the other
> record doesn't exist?

Then use a calculated field.

Luc.