Hi Chuck Glad you sorted out the Case question.
> Another interesting situation. > > I have several tables. > > I want to transfer data from one table into another using ScriptMaker. "Transfer" is not really a Filemaker word. What do you mean exactly? Import? Use Set Field? > 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.] You mean you are going to move data from one table to the other conditionally, depending on the value in this field? > So, I sort the FF table based on that field. OK... > 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. Hmmm... There are a few terms there that I'm not getting! Are you suggesting you have a relationship between another table and the one you call the FF table? What are the relational keys for this relationship? And again 'stuff' is not a Filemaker function. Are you using Set Field? Or something else? > How does one access the sorted records of a table from a different > table? Sort order doesn't really matter to a relationship. The sort order of the relationship itself does, though, if you are trying to Set Field from the one side to the many side of a relationship. But... Really this is just shooting in the dark. If you post your script and perhaps explain any relationships involved, it would be much easier to understand your problem. Steve
