Hello, i have a form running that does several things after being submitted, currently it writes the output to the screen so the users can see what they submited, it then adds a record to a database file and hopefully very soon it will also be saving the output to a .txt file (still working out the kinks of that one). Anyhow i was looking to add a Work Order number to each record as they are submited. I would obviously want to start at whatever number, say 100, and have that be put into the database for the first record, then as future work orders are submited have them go up sequentially, 101, 102, etc. The Database i am working with is a Visual FoxPro Database if that makes any difference, i just have not been able to find anything to even get me started on this. Thanks for any help/ideas.

Well, what I do in these situations is to make an SQL query in the database and order them according to the index number (also through the SQL statement). After this you should simply move to the last record and add one to the index number found here!

There most likely several other options, but this is working for me in most cases. I think you can use the automatic numbering from inside the database as well, but I do not know how.

Hope it helps!

Jacob.