Hi,
I haven't found the reason why but I deleted the relevant table and re
created it, the self relationship is now working with a calculation as
the key.
No idea of the difference in the two tables, however its working so I
guess I shouldn't worry.
Lee
Lee wrote:
As soon as I add or use it singularly the calc field negates the self
relationship even if there is already a working key that allows the
self relationship.
Lee
John Haley wrote:
I am not sure why what you are doing doesn't work, but can you just
use both the fields separately since you can have multiple keys in FM
8.5?
On Feb 14, 2008, at 10:19 PM, Lee wrote:
You may have read my earlier problem relating to a self relationship
in 8.5.
A self relationship works fine in 8.5 as long as I don't use a
calculation field as the key. It worked in FM6 using a calculated key
is this a problem in 8.5 ?
Lee
--
