setting date field

[macavity]

I have a script which uses dates entered into 3 repeating fields (10 repeats each) to create up to ten new records, each of which displays one set (ie 3) of the dates.

Those three dates appear in the new records in a repeating field as well (with 3 repeats)

Sounds easy, right?

But: With "set field" dates are only copied into the first of the 3 repeats. Although the script includes instructions to copy dates into repeat 2 and repeat 3, they remain empty.

Nor does the insert calculated result function work (result equals date), even when I change to the appropriate layout in the script.

The only thing that does work is copying and pasting, which is an enormous hassle to program.

Am I doing something wrong, or is this another FileMaker feature?

[LiveOak]

The first thing you're doing wrong is using repeating fields! .

You're correct this doesn't work. The only easy workaround is to use a global date field. Set Field from the first repeating field to the global data field and then from the global date field to the second repeating field. -bd

[This message has been edited by LiveOak (edited November 20, 2000).]

[macavity]

Thanks for the advice - I'll do that.

I know using repeating fields is a mistake, but I'm stuck with them - the database has evolved from a much older one and I don't want to make major changes now.