Tabe1-Product_details… columns- product,weight Table2-
transact…columns-product,weight,calcqty,Qty,date table1 has product
names and weight of 1 qty table2 -using ref and partof… in form
view…user selects products, enters weight
,calcqty=lookup([Prod...