I have 1 form call purchase order.
In this form I have 1 field call PO Number which will display the value automatically when the page was displayed. Each time when the page was displayed, the value will increment.
When user has filled in all the data in the form this value will be insert into PO table.Below is the database structure: