I'm having a problem with the script step "Lookup" with FileMaker 7. The lookup works correctly if the user is running the database from the host computer. The lookup fails if the user is connected via IWP. Both files are setup for IWP.

What changes with lookups when IWP is involved?

I'm not abel to explain why it behaves like that but you should use the Lookup( inside a calcfield instead!!!

--sd

Making the field a "calculation" field and putting the Lookup() there made no difference. The script still works when it is run from the database host, but still fails when run from an IWP cliet.

LookUp(Mail_1::EmailAddress;"??")

This statement returns the failure result when used in a script or in the definition of a "calculation" field only when the connection is via IWP.

Edited September 20, 200520 yr by Guest

Problem Solved

Moving both tables involved in the lookup() into the same file solved the problem.

I don't understand why the separate files didn't work for IWP connections, but at least it is working now.

... I don't understand why the separate files didn't work for IWP connections...

I've seen this too, the solution is to use a single file. Anyone know exactly what the problem is and if there's a workaround (other than a single file...)?