Andrew:

I know a number of my clients would appreciate a warning if they try to enter an order with the same reference number as an existing order for that customer.