Multiple file lookup into one field

[fabravo]

I have a client who has three databases that he wants to tie together. He wants to be able to put in a phone number in the 'order' database and have it pull from either the 'client' or 'vendor' database, depending on where it finds the data. Is this possible? I have tried all sorts of things, but have been unable to make it work. Please advise.

Thanks!

[Delta Tango]

You could write a conditional lookup using the lookup function.

For example:

If(

Your Condition;

Lookup ( lookupField ; "none" );

Lookup ( lookupField2 ; "none" );

)

[Vaughan]

I never knew the Lookup function existed. When was it introduced? (I only go as far back as FMP 8.5 and it in there.)

[comment]

In version 7.