getting related records

[Stackless]

I am trying to get all of the records from a database.

this is the scrpit i am working on...

tell application ...

tell window ..

get data of cell "#" of current record

set x to result

end tell

tell window ...

show

show (every record whose cell "File number" contains x)

end tell

go to window ...

tell window ...

activate

do script ...

end tell

end tell

i have also tried

get every record whose cell "File number" contains x

nothing works... any help is much appreciated...

Edited January 19, 2006 by Guest

[Thanh]

Is it simpler to write a script in your database and have Apple Script calls that script?

Just a thought.

[Søren Dyhr]

What you "Thanh" seems to have forgotten already is that GTRR(SO) under FM7 only takes you to the current records related records, so if you wish to find the invoices where you sold the last item of a certain kind, are you deep into violating developer ethics like tampering with clipboard contens etc. Further more did GetNth( only showup this summer at the introduction of FM8.

I've made a template that shows a way to accomplish it with FM7.

--sd

SetsOfInvoices.zip