product inventory for multiple locations

  • Thread starter Thread starter Russ via AccessMonster.com
  • Start date Start date
R

Russ via AccessMonster.com

Help!!!
Need to make a database to help control product inventory for multiple
locations, what suggestions can anyone provide?
 
I would use a summary and a detail table to monitor the inventory. The
detail table would contain the specifics per location, the summary table
would contain the total inventory
 
Ok, so I would a product table with part number, description, cost etc.. Then
have a product location table with location id, on hand order level and order.
Is this what you are suggesting, is this the best way?
 
Would that not make a very large table?
If I have 1000 products and 3 locations the location table would have 3000
records.
Ok, so I would a product table with part number, description, cost etc.. Then
have a product location table with location id, on hand order level and order.
Is this what you are suggesting, is this the best way?
I would use a summary and a detail table to monitor the inventory. The
detail table would contain the specifics per location, the summary table
Click to expand...
[quoted text clipped - 3 lines]
Click to expand...
 
How about ---
TblLocation
LocationID
Location

TblProduct
ProductID
PartNumber
Description
UnitCost

TblLocationInventory
LocationInventoryID
LocationID
ProductID
Inventory
EconomicOrderQuantity


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee.
Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Contact me.
 
PC Datasheet said:
If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee.
Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Contact me.
Click to expand...

These 1000 (if at all a real figure..) is only the result of
-- 4 years abusing the newsgroups.
-- 4 years blatantly advertising and job hunting.

You just don't care about the newsgroups. You have no ethics at all.
You only care about making money, and you act as if the groups are your private hunting ground.

-- You abuse this group and others for job-hunting and advertising over and over again
-- You are insulting lots of people here when they ask you to stop this
-- You posted as Steve, Ron, Tom, Rachel, Kathy, Kristine, Heather and ??? while asking questions
(the latest 'star's': 'Access Resource' and Tom (e-mail address removed))
-- You try to sell a CD ($125,--) with FREE code you gathered from these groups here
-- There even has been a 'Scam-alert' about you which has been explained recently in the thread 'To all':
http://groups.google.com/group/comp.databases.ms-access/msg/46038ba2954261f9?hl=en
-- Also recently it became clear that you have been spamming innocent people asking questions:
http://groups.google.com/group/comp.databases.ms-access/msg/4f76d0ed3e5f58ad?hl=en

So why would ANYBODY ever trust a person like you and hire you?
********************************************************

Explanation and more on this answer to Steve:
http://home.tiscali.nl/arracom/stopsteve.html

Arno R
 
Thanks PC Datasheet, that is something like what I have, maybe I am missing
something. Would that not make a very large table? If I have 1000 products
and 3 locations the location table would have 3000
records? Would this be slow?

ProdID Location
123 Location A
Location B
Location C

125 Location A
Location B
Location C
 
It should not be slow. Make sure you set up your relationships so the proper
indexes are created.
 
Back
Top