Hi all newbie to filemaker. I have this script that I am writing to add the detail records to a separate table. It seems to work fine except it does not fill the key field with the proper value. I have checked the relationships and it is set to allow adds. It also works if I hard code it in the script. So it must not be pulling the value from the header table when it creates the detail. Can anyone help? Here is the code of the script. Thanks in advance.

Jeff Williams

Edited June 23, 200916 yr by Guest

You cannot refer to the related ProjectID, because at this point there is no related record in Projects. You need to load the currently viewed project's ID into a variable BEFORE going to the other table, e.g.

Set Variable [$projID ; Projects::ProjectID ]

Go to Layout [ Time ]

New Record

Set Field [ Time::ProjectID ; $projID ]

...

Or use the script parameter to "carry" the ProjectID.

That worked perfect. Thank you as always. Great help!