On Jul 12, 2006, at 10:23 AM, Gary (Lists) wrote: > data order in the resulting list is field-order dependent, or, > rather > it is dependent on the layout which is targeted by the "tell", > meaning that any output row's column order needs to be > carefully > planned and the script executed toward/against that layout > always. > (This used to be able to be handled by the "tell layout 0" > method, > and FM 6 can take advantage of that feature.) > > tell layout 0 > > [Mark's lively script] > > end tell -- of 0 > > > This could really save the OP some time. Good idea, Mark. In my script I specified a layout to get the fields formatted and in the same order as the user sees them. I actually sent Joe a database that had a specified export, a filemaker script and then an applescript which used both of them. -Mark Who keeps trying to learn SQL but never has the time.