By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

User Level

P: n/a
Hi

I am trying to create a database with three tables

Table - Inventory
Table - Received
Table - Issued

I want to enter or change a record ( field -Qty) in the Received table (or
form) and have it automatically add the amount for the corresponding record
(field -Qty) in Inventory Table. Also when I change the Qtry field in
Issued Table (or form) I want it to subtract the amount from the
corresponding record Inventory.

Any help would be appreciated

Marlie
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi Marlie.

Big question. For an introduction to the issues involved, see:
Inventory Control - Quantity On Hand
at:
http://allenbrowne.com/AppInventory.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Marlie" <mt***@thezone.net> wrote in message
news:c1**********@nntp-stjh-01-01.rogers.nf.net...

I am trying to create a database with three tables

Table - Inventory
Table - Received
Table - Issued

I want to enter or change a record ( field -Qty) in the Received table (or form) and have it automatically add the amount for the corresponding record (field -Qty) in Inventory Table. Also when I change the Qtry field in
Issued Table (or form) I want it to subtract the amount from the
corresponding record Inventory.

Any help would be appreciated

Marlie

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.