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