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.
cheers
Tom
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.....
