• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Filemaker 8 Help - Find a record
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Filemaker 8 Help - Find a record


  • Subject: Re: Filemaker 8 Help - Find a record
  • From: Chris Prew <email@hidden>
  • Date: Thu, 30 Nov 2006 08:59:37 -0600


On Nov 29, 2006, at 8:17 PM, Malcolm Fitzgerald wrote:


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

Yep. This looks like a pretty simple function, right? I just don't get it.

Chris


_______________________________________________ Do not post admin requests to the list. They will be ignored. AppleScript-Users mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: 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>)
 >Re: Filemaker 8 Help - Find a record (From: Malcolm Fitzgerald <email@hidden>)

  • Prev by Date: Re: AS and shell
  • Next by Date: Importing files into iTunes
  • Previous by thread: Re: Filemaker 8 Help - Find a record
  • Next by thread: Re: Filemaker 8 Help - Find a record
  • Index(es):
    • Date
    • Thread