Hi Tom,
On Jan 3, 2008, at 2:55 PM, Tom Elliott wrote:
Chcuk
the order in which one table (more accurately "table occurrence")
'sees' the records of a related table (occurrence) is determined by
the sort order (if any) defined for the related table (occurrence)
in the relationship definition - if no sort is defined then the
records are 'seen' in creation order. For a portal showing the
related data, you also have the option of overriding the
relationship sort by defining a portal sort.
So the solution to my problem is setting a sort order for the FF
table as it relates to the top-level relational table.
Thanks!!!
Happy New Year,
Chuck
On 3 Jan 2008, at 21:44, Chuck Pelto wrote:
....in another table.
Another interesting situation.
I have several tables.
I want to transfer data from one table into another using
ScriptMaker.
As part of the process, I want to know when a particular field in
the one table has changed value. [Note: We're going from a flat-
file (FF) table to a relational series of tables.]
So, I sort the FF table based on that field.
However, on the relational side, when I access the first record in
the sorted FF table and stuff data from it into the relational
table, it's not giving me the data from the sorted FF table. It's
giving me the data from the unsorted first record of the FF table.
How does one access the sorted records of a table from a different
table?
Regards,
Chuck
P.S. Solved the problem of the CASE IN POINT....a series of
typos.....how embarrassing.....
