Jump to content
Sign in to follow this  
Jack

non incrementing serial numbers

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Hi Vaughan !

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

Thanks.

~ jack

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.