On 2008 Feb 14, at 19:47, Lee wrote:
Hi,
I've been travelling nicely on 8.5 for a while now, however, I've
just had to rebuild an old program of mine from FM6 into 8.5 In the
past all other rebuilds have been fine. However, on this occasion
I've met a brick wall in one area. In the previous FM6 version I
had a screen where a record was created in, say, January for a
client and the data entered, when that client had a second entry
made at a later date, in say August a self relationship would
display on the right side of the August screen the data that was
entered for this client on the January record.
The self relationship was based on a calculated field of 2 other
fields in that file. The same data fields were selected from the
self relationship
and placed on the right side of the screen thus showing what was
entered on the previous January record.
I have tried to do the same in 8.5 unfortunately while the self
relationship field is working and looks the same on both the
January and August record, the fields selected from that self
relationship just do not work and display nothing.
The reason for doing this exercise is that it saves the operator
having to search for the old record to compare data and then you
don't have the same data on the same screen.
Any suggestions please or is there another way to achieve the same
result.
3 things to check for:
(1) Have you set the calculated field to be stored as "indexed"?
(2) Have you checked to be sure that the result of the calculation is
of the proper type (for example, number rather than text, date, etc.)?
(3) Near the top of the calculation window, on the right side, is a
drop-down menu that says "Evaluate calculation from the context
of ...". Be sure you've selected the most fundamental table
occurrence available (the one whose name exactly matches the name in
the "Tables" definition) and furthermore that the fields you've used
to create the calculation are ALSO taken from that fundamental table
(as indicated by the drop-down menu directly above the list of
available fields).
