Field to indicate existance of a related record in another DB

[Graham S]

Hi,

I have two related Database's, related by a product code field.

In Database A's records I'd like to have a field display whether or not the current record has a related record in Database B.

I cannot work out how to do this.

[Ender]

Try:

case(length(Database B::product code); field)

Edited November 26, 2005 by Guest

[Graham S]

Perfect.

Thanks.

I'd never have worked that one out from the online docs.