Log in
Hot & Trending on FMT

FileMaker Answers

A FileMaker Pro Question, Answer and Tip Collaboration.

Share this post:
Responses (2)
  • Accepted Answer

    Thursday, January 30 2014, 06:39 PM - #permalink
    Go to Layout ["Parent" (Parent)] This is the table where Parent records are created. You want to create a new CHILD record. You're in the wrong place

    New Record/Request See? Now you just created a new PARENT record. Not what you wanted, right?

    Instead you want to trap for the parent table's ID field value, do the equivalent of scribbling it on the back of a piece of scrap paper...

    Set Variable [$ParentID; Parent::ID]


    ... then go to the CHILD layout and create a new record THERE instead...

    Go to Layout ["Child" (Child) ]
    New Record/Request


    ... and set the RelatedParent field to the parent table ID that you put into that variable:

    Set Field [Child::RelatedParent; $ParentID]

    ... then go back to where you came from:


    Go to Layout [original layout]



    meanwhile...


    Get(Parent:ID) <—— FileMaker is complaining about this. It is INDEED not a valid Get function.

    You don't use Get to obtain a field value, you just reference the field as Table, two colons, and fieldname: Parent::ID


    Note that you only put one colon.


    Get functions are quite specific. Most of them reference values that are NOT in fields:

    Get (CurrentDate )
    Get (ActiveModifierKeys)
    Get (SystemPlatform)
    Get (DesktopPath)

    etc
    The reply is currently minimized Show
  • Accepted Answer

    Olly
    Olly
    Offline
    Thursday, January 30 2014, 06:40 PM - #permalink
    Wow, thank you so much! And thanks for taking the time to make sure I understand what I'm writing!

    Really appreciate the help -- works like a charm now
    The reply is currently minimized Show
Your Reply