>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.
YOu don't necessarily have to make a view field to do this. Just set the controlsource for the column to a form method that calculates the amount and returnd it.
Erik Moore
Clientelligence