Jump to content

Creating New Record with New Serial #


This topic is 7768 days old. Please don't post here. Open a new topic instead.

Recommended Posts

quote:

Originally posted by JLPSch:

I am updating an order program I wrote to include a function to process backorders. I would like to write a script to create a new record to process a backorder, but I'm stuck on how to create the new order no. for the backorder. It has to be combination of the original order number with a -001 to it. I also have to be able to process another backorder off the first backorder and assign it a new order number. Any suggestions would be appreciated. Thanks!

Start by changing the "Order Number" to a text field. Then simply append "-001" to the end of the field. You can use any method you like for determining what numnber "-001", "-002", etc.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.database-resources.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=

Link to comment
Share on other sites

  • Newbies

I am updating an order program I wrote to include a function to process backorders. I would like to write a script to create a new record to process a backorder, but I'm stuck on how to create the new order no. for the backorder. It has to be combination of the original order number with a -001 to it. I also have to be able to process another backorder off the first backorder and assign it a new order number. Any suggestions would be appreciated. Thanks!

Link to comment
Share on other sites

This topic is 7768 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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