M
Maury Markowitz
I use Continuous Forms a lot, and have a new task that would best be served
in the same way. The form shows "orders", each of which contain several "line
items".
This might be a little hard to descrive...
The items are "additional lines" on the order, like tax and other fees.
There is only one of these per order, and they are optional. So for instance,
one order might be...
$100 widgets
$10 tax
$1 restocking fee
another might be
$250 gizifas
$10 tax
In other words, any order can be represented in a single line, like this...
item total tax fees
widgets $100 $10 $1
gizifas $250 $10
Now in general I know how to do this "rotation" with a CASE statement in a
view - I use this in many places already. However the resulting recordset is
not editable.
Can someone suggest a way to do this so that the fields will remain
editable? IE, if someone changes the fees number to $2, the correct item row
should be modied, and nothing else.
Maury
in the same way. The form shows "orders", each of which contain several "line
items".
This might be a little hard to descrive...
The items are "additional lines" on the order, like tax and other fees.
There is only one of these per order, and they are optional. So for instance,
one order might be...
$100 widgets
$10 tax
$1 restocking fee
another might be
$250 gizifas
$10 tax
In other words, any order can be represented in a single line, like this...
item total tax fees
widgets $100 $10 $1
gizifas $250 $10
Now in general I know how to do this "rotation" with a CASE statement in a
view - I use this in many places already. However the resulting recordset is
not editable.
Can someone suggest a way to do this so that the fields will remain
editable? IE, if someone changes the fees number to $2, the correct item row
should be modied, and nothing else.
Maury