Unsure as to which forum this issue should be located, so feel free to move it & Apologies in advance for the lack of proper terminology.
I have a simple PO database for our company’s I.T. purchases.
At the moment the Tbl_POrdershas PO_No as the primary key field and is set as Auto-number. The format is set to 19IT”000, and is set to increment as per this screenshot
Form :
After clicking new (blank) record, the P.O. Number text box changes to this
When a PO Date is entered, the PO Number text box displays the auto-incremented PO number, such as 19IT116.
(This is all good & it works perfectly)
Problem:
Our stores/procurement department want us to include another field (Stores_PO)
This should be a combination of their PO numbering format (650000, ) and our I.T. PO_No (PO_No) such as 6500001-19IT116
How do I facilitate the Stores_PO number??
That textbox must auto-populate , first with the auto-incremented number 65000001 etc and it has to contain our PO_number (19IT116) etc i.e 6500001-19IT116
I have a simple PO database for our company’s I.T. purchases.
At the moment the Tbl_POrdershas PO_No as the primary key field and is set as Auto-number. The format is set to 19IT”000, and is set to increment as per this screenshot
Form :
After clicking new (blank) record, the P.O. Number text box changes to this
When a PO Date is entered, the PO Number text box displays the auto-incremented PO number, such as 19IT116.
(This is all good & it works perfectly)
Problem:
Our stores/procurement department want us to include another field (Stores_PO)
This should be a combination of their PO numbering format (650000, ) and our I.T. PO_No (PO_No) such as 6500001-19IT116
How do I facilitate the Stores_PO number??
That textbox must auto-populate , first with the auto-incremented number 65000001 etc and it has to contain our PO_number (19IT116) etc i.e 6500001-19IT116