Can I create a combo order number without code?

[marcondes]

I need to generate order numbers with a combination of StateID+VendorID+Number of sales by that vendor.
For example: StateID=55, VendorID 112, number of transactions to date (including this current one) by the vendor=73... my order number would be 55112-73.
I'm new with access and don't know code.

 

[B827]

You could use a query on the table(s) and have a field in the query as follows:

SerialNumber:TableName!StateID & TableName!VendorID & "-" & (PreviousOrders+ 1)


to get the number of previous orders use the Dcount Function Sandy