I am facing this issue for a couple of weeks and i am using MS Access.
My issue is that I would like to have My PO number auto increase, however the PO number is not my primary key, instead ID is my primary key. I used ID as my primary because under one PO, it will have more than one fabrication.
I construct my running number table as below: ID Autonumber PO Number Shorttext
After setting up the PO number, i would like to link it to my main table so that i will be able to search the PO number and all the data that are store under the PO number that i am searching will show on on my subform. I would also like that the PO number will not increase until i have click on the "add" button on my form.
How can i do that?
Thank you.