• 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: Trouble with simple Find in FMP data base
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Trouble with simple Find in FMP data base


  • Subject: Re: Trouble with simple Find in FMP data base
  • From: Bill White <email@hidden>
  • Date: Fri, 23 Jan 2004 13:12:44 -0500

> set myValue to "00002"
> set myCell to "InventoryCode"
> set myTable to "LineItems.fp5"
>
> tell application "FileMaker Pro"
> find myValue in cell myCell of database myTable
> end tell

Chap,

Try this:

set myValue to "00002"
set myCell to "InventoryCode"
set myTable to "LineItems.fp5"

tell application "FileMaker Pro"
show (first record of database myTable whose cell myCell is myValue)
end tell

Note: you can use "last record" or "every record" instead of "first record"
depending on what you're trying to accomplish.

HTH,

Bill
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.

  • Follow-Ups:
    • Re: Trouble with simple Find in FMP data base
      • From: Chap Harrison <email@hidden>
References: 
 >Trouble with simple Find in FMP data base (From: Chap Harrison <email@hidden>)

  • Prev by Date: Re: Trouble with simple Find in FMP data base
  • Next by Date: RE: Inheritance, Context, Scope, etc.
  • Previous by thread: Re: Trouble with simple Find in FMP data base
  • Next by thread: Re: Trouble with simple Find in FMP data base
  • Index(es):
    • Date
    • Thread