I need to show the extended amount (price times quantity) in the line items grid of my order entry form. There's a one-to-many relationship between orders and order lines. Could this be done with an updatable view? Are there any other approaches?

Thanks.