Lookup on an unstored field won't work

[peter lomas]

I have two related files A & B related by field "ref no" in file A and "reference" in file B

I have an unstored calculation field in file B that uses GetSummary to give me a total amount paid per "reference".

I have a field in file A that uses lookup to get the unstored calculation from file B.

when I run the lookup I am returned a "null" value.

There is a value in the field in file B and when I change the focus of the lookup in file A to another field from file B the lookup works correctly.

We have just converted the files from v5.0 for Mac OS 9 to 8.0v3 on Win XP.

The above situation worked fine on the Mac but does not work on WinXP.

Any body have any ideas?

[Søren Dyhr]

No need to use the GetSummary( just pull in the the real summary field from the related table to the viewer layout, and btw no lookup.

--sd