I have a computed column which is my Bid Number. It is the composite of three columns. I open the form and the data is there for all to see. When I add a new record using bound controls, the computed column does not update. It makes sense that it wouldn't since I didn't force a retrieve from the database.

I thought I'd be clever and put code in the Entity object to update the Bid Number if it was blank and I had all the required fields filled in. When I tested it, it squeeled because the Bid Number is read only.

Any suggestions on how to handle this?

Thanks,
Jeff