Importing data

[Tsong]

Can anybody help me before I get frustrated with FMP. Is it possible to get a data from record one if I am on record two? If so, how? I need a data from the first record in a calculation field of the second record. Thanks for any help you can spare to me.

[IdealData]

Yes.

Use a relationship. The relationship will need to use a "self join" (the file is related to itself), and use the record ID or serial number (or similar) as the match field.

Then you can use the related field as part of your calculation.

Bear in mind that you won't be able to store the calculation result, as it is dependent upon a related field.

[Lee Smith]

Have you tried the Insert From Last Resord script step

Lee