copying one field into a different field.

[LeStew]

Ok here's the challenge.

Let's say I have 3 timecode fields in a record.

TCIN TCOUT TCDuration (all this timecode stuff works perfectly thanks to this forum BTW:)

I want to be able to have FMP10 automatically copy the TCOUT into the NEXT record for the TCIN.

For example:

Record 1

TCIN TCOUT TCDuration

01:34:56:15 01:35:56:15 00:01:00:00

Record 2

TCIN TCOUT TCDuration

01:35:56:15

I can get it to where it would copy the SAME field across records but not different fields.

I apologize if this topic has already been covered but I couldn't find it in the forums. I'll gladly be pointed to an old topic!

LeStew

FMP10 Mac and PC

[comment]

I want to be able to have FMP10 automatically copy the TCOUT into the NEXT record for the TCIN.

Well, it depends on what exactly is "the next record". Do you want this to happen when you create a new record (as when entering a large amount of records in sequence)?

[LeStew]

Well, it depends on what exactly is "the next record". Do you want this to happen when you create a new record (as when entering a large amount of records in sequence)?

yes. As I wouldn't need the TCIN to be different for the clip after the immediate next clip.

[comment]

You could set the TCIN field to auto-enter a calculated value =

GetNthRecord ( TCOUT ; Get (RecordNumber) - 1 )

[LeStew]

Thanks! I will try that. Will post results