[FP7]

[Jarvis]

I'm really struggling here and I hope someone can help me.

I'm working on a solution for my cabinetshop and I can't seem to get past this current roadblock.

I need a script which will copy a value from the previous record and paste it into a similar field in the current record.

Loosely stated, the condition would be:

IF Quantity of Doors is >1

Set Field (DOORSIZE) to be equal to (DOORSIZE) posted in previous record.

I guess what I want is something like a conditional LOOKUP, but I want the

LOOKUP to only occur in the event of the trigger QUANTITY >1.

Can this be done in Filemaker 7 or do I need to try Developer 7?

Thanks for any guidance.

Jarvis

FileMaker Version: 7

Platform: Mac OS X Panther

[CyborgSam]

Jarvis->

You could define one field that does the lookup regardless, and then a calculation field with the If statement that returns the other field If Quantity > 1.

Will that work?