|Subject||doing a select in a Computed by column|
I have a order system, there is an order table and an orderItem table. I would like to make the subtotal column on the order table to a select from the orderItems table to find the subtotal. Can I do that in a computed field? If so, how? Is it a wise thing to do? If not, what are the other options?