Hi,

im pretty new with access 2007, i decide to use northwind template.
In order detail both form, i have 2 different Qty, the original Qty is the
Qty that will link to Inventory and I add another field Qty1 for invoice
purpose. For example, I got 1 roll of tape, 1 roll will be cut into 10 pcs.
We need to bill according to customer request qty 10, but actual qty sold is
only 1. Anyone come across this issue. How to modify it w/o effect the
function?

table/form as below:-
ID
ORDER ID
PRODUCT ID
QUANTITY (FOR INVENTORY)
QTY1 (FOR INVOICE)
UNIT PRICE
AND SO ON

Is there any easy way to do? I dont know anything about macros...thanks in
advance.....coco111

--
Message posted via http://www.accessmonster.com