I searched and didn't find any threads trying to do what I am trying to accomplish. I have a table that gets it's order data from a form page. I'd like to auto number each order, prefixed with the date. Currently each order has an order number like this: 00001, 00002, etc. I'd like the table to auto number the orders like such: 2019031001, 2019031002, 2019031003, etc.
Any help or suggestions is much appreciated.
Joey