Stock Update

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nkormath - 09 May 2005 12:25 GMT

Please help me

In my database there is 2 tables, named "MasterStock" and "Voucher".

MasterStock
--------------
StockId (autonumber) - Key field
SotckDate (date)
BeginingNo (Text) - (10 charectors) format "0000000000"
Quantity (Number)- 0 decimal

Voucher
----------
VoucherNo (Text) - (10 charectors) format "0000000000" - Key field
StockId (Number) -duplicates - OK

Here we want to update Voucher table based on the data in MasterStock.
For example, We are inputing Begining number and Quantity in a form, it
should check if any voucher existing in "Voucher" table within this criteria
by a loop. If not, add to "Voucher" until the quantity met.

Please help me in this case...

Thanks in advance

Reply to this Message

Tim Ferguson - 09 May 2005 17:51 GMT

> Here we want to update Voucher table based on the data in MasterStock.
> For example, We are inputing Begining number and Quantity in a form,
> it should check if any voucher existing in "Voucher" table within this
> criteria by a loop. If not, add to "Voucher" until the quantity met.

I think you mean by this that the MasterStock.Quantity is meant to reflect
the number of Voucher records referencing that MasterStock record.

Bad Idea.

If you want to know how many Vouchers you have, simply count them: either
using a DCount() function, or, better, by joining the tables together and
using a COUNT aggregate function in the query. You just will not be able to
keep the two values in synch. What will you believe when you have two
different counts for the same thing?

Hope that helps

Tim F

Reply to this Message