Mailing Lists: Apple Mailing Lists

Image of Mac OS face in stamp
 
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Filemaker 8 Help - Find a record




On 30/11/2006, at 9:21 AM, Chris Prew wrote:


Hi -- I've been using Applescript with FMP 5/6 for a long time, but writing Applescripts for FMP8 is driving me batty.



I need to convert a lot of scripts that read text input, find the text item in FMP in a certain cell, and then grab data from the record in question, and repeat ad infinitum. Anybody shed some light on what the proper context for this is?


set store_number to (whatever the store number is from the list)

tell application "FileMaker Pro Advanced"
tell database "CorpDB"
go to layout "MyLayout"
show (every record of table "Stores")
show (every record of table "Stores" where cell "StoreID" is equal to store_number)


                end tell

        end tell


When I do this it'll find the store number for the first store number on my list, but it'll never go beyond that store.

the field "StoreID" is on layout "MyLayout" isn't it?

malcolm

_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/applescript-users/email@hidden
Archives: http://lists.apple.com/mailman//archives/applescript-users

This email sent to email@hidden
References: 
 >Filemaker 8 Help - Find a record (From: Chris Prew <email@hidden>)



Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2007 Apple Inc. All rights reserved.