Is it possible to have the customerID be the order number? And if a customer has multiple orders be something like CustomerID-x, where X is the 2nd, 3rd, 4th order etc.?
Is it possible to have the customerID be the order number? And if a customer has multiple orders be something like CustomerID-x, where X is the 2nd, 3rd, 4th order etc.?
That would take some customization (source required), there's no built in setting for that. You'll need some changes to the DB as well, as we have constraints in there that apply to that field.