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

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.

That worked...Thank you so much.....now I can relax!!!