Inventory & Quantity in Hand

K

Karan

Mr. Browne,

Firstly, i am sorry for CC to your mail ID forgive me. I want the below
said to be done. i don't have a clue about it. please help me !

As i said earlier that i want to maintain our inventory, i want to take the
Quantity On Hand. I have gone through your website and done the tables
accordingly. The Acquisition, Acquisition Detail and Stock Take Tables and
the remaining tables exist as mentioned(like the Northwind Traders Database)

1) Acquisition Table contains > Field1: AcqID(AutoNumber) Field2:
AcqDate(Date/Time) and Field3: AcqNote (Memo)

2) Acquisition Detail Table Contains > Field1: AcqDetailID(AutoNumber)
Field2: AcqID(Related to Acquisition Table) Field3: ProductID (Related to
Product Table) Field4: Quantity(Number) Field5: UnitPrice(Currenty)

3) Stock Take Table Contains > Field1: StockTakeID(Autonumber) Field2:
StockTakeDate(Date/Time) Field3: ProductID (Related to Product Table)
Field4: Quantity(Number)

You have given the code for Quantity On Hand in your Website. Please help
me in how to put in to a Event Procedure.

I have created the reletionships also according to your sample Function.
Now i want to put the Function onHand. I don't know how to do that and also
do i need to build any query before i can calculate stock on hand. please
help me in this regard. I am under tremendrous pressure from all corners.
I want to do this, which will help me in a great deal. Any tips will be
highly valued.

Thanks and waiting for your valueble reply !!

Thanks in advance

Karan
 
Top