var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Help... with my table
hi there... im creating a database to reduce mistakes for data entry purpose.
table 1: product code | received quantity etc..
table 2: product name | vendor name etc..
form 1: product code | received quantity etc..
result : product name| product code| received qty| vendor name
the operator will input using form 1. i want that the received quantity is accumulated in table 1, everytime the operator input received quantity for a same code....
code item qty
343343 Tshirt 200
343343 Tshirt 120
so the result will appear the total as below
343343 Tshirt 320 and not repeated data...
Please could you tell us your exact table structures? This will be important to getting the correct answer.
ur codings are working excelent.
im attaching my workbook here...
the operator will key in entry by using 'Data Update' form.
i want if the same item key in repeatedly, the received quantity is totalled and not repeated record.
and, how to add formulas... for example, in 'stock amount', i want to add 'unit price' x 'opening stock'.