Please I am writing an system application for a company that must generate inquiry id and order id automatically. Whenever a customer makes a new inquiry or new order by clicking the add button, an automatic number should be displayed in the text box and when it's saved, it should be saved in the database access.
The order and inquiry numbers should consist of integers and strings. e.g: "CT0001, RT0002"
Please can someone kindly help me with this as soon as possible, hopefully?
Thank you all for your assistance in advance :)