Jump to content

getting related records


Stackless
 Share

This topic is 5728 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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 by Guest
Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5728 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.