If Exists

[faada]

I'd like to create a field which will return a 'Y' or an 'N' based on the existence of a value in a field in a related record.

ie. If there is a record in related table X which has the value "1003" in field 'UID' then "Y"

Can anyone help me out with this?

'preciate it.

Joey

[BrentHedden]

Use the Case function -

Case( X::UDI = "1003", "N","Y")

You could also do it this way with the same results -

Case ( X::UDI <> "1003", "Y", "N")

(I'm supposing that the field 'UID' is a text or number type)

-Brent