Invalid relationship

[David Jondreau]

I'm trying to figure out why a relationship is being flagged as invalid.

I'm working locally on an import file. This file is has a remote file as a data source. The local table is related to a remote table.

Some of the local fields are unstored calc, drawing from other tables in the remote file. I've got a relationship built on those calcs, which is coming up as invalid when I try to search on a related field. It's fine for viewing data.

Am I missing something?

[Vaughan]

It will be the unstored calcs. One or more of them is not valid in Find mode because there is no "current record" to base the value from.

This has bitten me a couple of times...

Edited September 24, 2009 by Guest