non incrementing serial numbers

[Jack]

I currently have a field in a purchase order that looks at the previous order and increments that number by 1, unless the purchase order has multiple pages (which are actually multiple records).

In that case it simply copies the existing order number without incrementing it.

It occured to me that instead of looking at the previous order number and incrementing that number, it would be better to use the serial number calculation. (I welcome your thoughts on that. )

I would like to use a calculation that says: if page field = "more", increment serial number by zero, otherwise increment by 1. (or visa versa)

But I can't get FMP to accept my calculation.

Thanks, guys.

~ jack

[Vaughan]

A better method would be to have a purchase order master record, with related purchase order pages. Make as many pages as you want.

The master record then uses a simple auto-entered serial number. No mucking around with calculations or field values.

[Jack]

Hi Vaughan !

Can you give me a little more direction regarding the master record/ related pages ?

Thanks.

~ jack