Set Field Script Not Working

[Kristen]

I have 2 databases related by constant throught the relationship "donor". One is a calander type database. What I am trying to do is this. Click on a date on the calander, this copies the date into a DateField in the calander db. Then through an OK button that performs a script, this date should be set in another field in the related db. My script looks like this, and I can not figure out what is going on.

If[isEmpty(gNavigator)]

Show Message [buttons: "OK","";Data: "No date is selected"]

Else

Set Field [Donor:ScheduledTowDate, gNavigator]

End if

Any ideas where I have gone wrong, or how I can get this to work?

Thank you

[dbruggmann]

The second part of your script (after the

[dbruggmann]

Hello Kristen

Myself working on a german Fielmaker version, yesterday I didn't get the right english Scriptmaker terms for the call to external script. So here again, but this time in english Filemaker:

If[isEmpty(gNavigator)]

Show Message [buttons: "OK","";Data: "No date is selected"]

Else

Perform Script [sub-scripts, External:

[-Queue-]

The only problem I can see for this script step not working is if there is more than one record in the related file. If there is, then the Set Field step is setting the first related record in the related file, which is either the first record created in that file or the first record that would be displayed in a portal for that relationship, if the relationship definition has a sort defined.

If there is only one record in the related file, then both of these possibilities would point to the same single record, and your script should work.