insert AutoNumber field in form

[patheo]

Hello,

In the database attached, I have an order form that can add order items in a subform. Everything works fine but the end user has to enter the order id every time a new order is applied.
Please, can you help me set an autoNumber field that automates the Order id entries.

Thanks in advance,

[Seth Schrock]

In the Orders table, just change the OrderID data type to be AutoNumber instead of Number. That is all it takes.