Add Week to Previous Date Field

[braves]

I want to add seven days to the date in the previous record. I would also like to have my records redate the remaining dates at seven days apart.

Ex. If I add a record in the middle, Filemaker would change the remaining dates in the records.

Is this possible?

[Chuck]

Sure, just do it with a script. Have a field called gDate that is a global date field.

Go to Record/Request/Page [ First ]

Set Field [ gDate, Date_Field ]

Loop

[braves]

Chuck,

I just wanted to say thanks for all the help!

It works like a charm!

[Vaughan]

Err, just a quick note here (always tyhe pedant...)

Whenever you create a new record, that record is added to the "bottom" of the database. Even if you are browsing in the middle, the new record will always be the last.

The way to get a new record into the "middle" is to *sort* the database after the new record is created.

There, I feel better now. ;-)