Mr13MWZ Posted November 24, 2003 Posted November 24, 2003 I am new to the forum and have little experience with FM. I paid a co-worker at the time to create an operating system for my little home business. Now that I am having problems with the database, he has since moved with no additional contact information. Here is my problem. He built a purchase order DB where I create all of my new purchase orders. I use CTRL N to creat a new file and it has worked fine until now. There was a problem with the DB so I had to import a backup of existing records from a file created some time ago. I was currently on PO # 1103. Now after the import, although I show that I am on PO # 1103, when I try to create a new PO it automatically starts with #1061 and writes over the existing purchase order. I hope I am making myself clear. I need to find out to get this back on track so when I create a new file, it will choose the next number in order. Forgive me if this is in a wrong forum. I just dont know where it should go. Thanks Jim
Robert Kidd Posted November 24, 2003 Posted November 24, 2003 I think your purchase order No. is an auto enter serial number. Open the Purchase order database, Select define fields. Double click the "Purchase order no" field. Select the auto enter tab if it isn't already on top and check/change the next serial number to issue. Select Ok and Done. Create a new PO , it should use the new value you entered above.
Mr13MWZ Posted November 24, 2003 Author Posted November 24, 2003 That worked...Thank you so much.....now I can relax!!!
Recommended Posts
This topic is 7673 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 accountSign in
Already have an account? Sign in here.
Sign In Now