In a table I have fourteen fields event [x] [date] and numOfDays [x] [number].

The scheduling layout should contain the first record and last record. My idea was to use two global repeating fields globalFirstRecord and globalLast to display these two records in the same layout. I am only able to assign the values in the following way:

GoToRecord [First]

SetField [

Global or otherwise, in order to access the cells in a repeating field within a script, you will have to use the GetRepetition function to tell the script which cell repetition to set. Also when referring to a repeating field in any kind of calculation, you will have to tell which repetition in the repeating field to use. If you don't the FileMaker will just assume it the 1st rep.

HTH

I understand, but I am not able to alter the code and incorporate in a loop:

GoToRecord [First]

SetField [

Great Idea! But you can't do it. FileMaker cannot access a give repeat of a repeating field based upon a variable (field). I would probably use a relationship and a portal to build the tables. -bd