Update Query - Add a prefix?

[BJNK]

I am wondering if its possible to run an update query and add a prefix to the fields being updated?

The specific example is when we receive an order and not all of it can fit onto a truck it creates a back order. In the invoice form I have a "Create BackOrder" button that brings the CustomerID, CustomerPO, OrderID all over to the Back orders form, where the backorder information can be entered.

I was wondering/hoping how I could have the CustomerPO be prefixed with the letters BO, so it would be BO12345.

This is something they really want, having the prefix, and Im not sure how to do it. If it was up to me I would choose a different route, but they are very admamant about having the BO.

Thanks for any help/suggestions!

 

[PHV]

Use "BO" & CustomerPO when you pre-fill the Back orders form.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886