one field must be the same value from a next record!

[harjokom]

Hello, I have a problem

I have 3 fields: start, stop, and end.

Start & Stop are fields, where information is brought in.

The 'End'field must be calculated as follow. The 'end'field must have the same value as the 'start'field from the next record!

How can I do this, without writing a script that goes from the last throught the first record, and then use paste and copy?:?

All help would be very welcome!!!

Greetings from the Netherlands

Harjo Kompagnie

[Kurt Knippel]

If you are using seperate records, then do not use seperate fields. Simply have a Time field. You can then use the Auto-Entry options and set it to "Value from Previous Record". Finally all you need to do is to indicate whether the record is a "Start", "Stop" or "End" type.

You can also do some tricks with relationships, but that is more advanced and adds complexity without really adding any functionality.