• 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
FileMaker Related Cell Question
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

FileMaker Related Cell Question


  • Subject: FileMaker Related Cell Question
  • From: Jason Bourque <email@hidden>
  • Date: Wed, 24 Sep 2008 21:32:16 -0400
  • Thread-topic: FileMaker Related Cell Question

Title: FileMaker Related Cell Question
Hello,

I know how to access the normal cell, but how do I access the related fields on the layout? Thanks, Jason

tell application "FileMaker Pro Advanced"
        tell database "Marketing Landscape"
            show layout "Item Number History"
            
            tell table "Item Number History"
                
                try
                    set vRecsFound to every record whose cell "Item Number"'s cellValue is vItemNumber
                on error
                    set vRecsFound to {}
                end try
                
                -- return vRecsFound
                if vRecsFound is {} then
                    
                    set vNewRecord to create new record
                    
                    if gTestTF then
                        show vNewRecord
                    end if
                    
                    set cell "Free Product History UID" of vNewRecord to vFlyerSpecialUID
                    set cell "Item Number" of vNewRecord to vItemNumber
                    set cell "Macola Category" of vNewRecord to vMacolaCategory
                    
                end if
                
            end tell
        end tell
    end tell
 _______________________________________________
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/archives/applescript-users

This email sent to email@hidden

  • Follow-Ups:
    • Re: FileMaker Related Cell Question
      • From: Tim Mansour <email@hidden>
  • Prev by Date: Re: Batch Processing Image files
  • Next by Date: Re: Instructions after file check...
  • Previous by thread: Re: Script to Sync iTunes Libraries Between Macs
  • Next by thread: Re: FileMaker Related Cell Question
  • Index(es):
    • Date
    • Thread