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

Advanced Inventory Management

blyxx86
100+
P: 256
Hey everyone, I'd really appreciate your help here on how to pull this one off...

I'm trying to keep track of a serialized inventory by customer / customer location.

So far I've figured out how to maintain an inventory using Allen Browne's example, but that is for a single inventory location. I am essentially looking how to set up relationships for multiple locations. Also, since the equipment is mostly serialized the quantity of most items is 1 as the serial number makes it unique.

Any ideas on how to accomplish this? I am not looking for someone to create it for me, just guide me in the right direction.
Aug 6 '07 #1
Share this Question
Share on Google+
3 Replies


Rabbit
Expert Mod 10K+
P: 12,389
So... each customer will only be related to one location right?
Aug 6 '07 #2

blyxx86
100+
P: 256
So... each customer will only be related to one location right?
Sorry... Let me try to explain a little bit more.

Each customer will have many possible shipping locations, but will only have one warehouse location.

I'm trying to keep track of customer owned inventory more efficiently than it currently is being done.
Aug 7 '07 #3

Rabbit
Expert Mod 10K+
P: 12,389
Sorry... Let me try to explain a little bit more.

Each customer will have many possible shipping locations, but will only have one warehouse location.

I'm trying to keep track of customer owned inventory more efficiently than it currently is being done.
So, from the sounds of it, your tables would be designed like this:

Expand|Select|Wrap|Line Numbers
  1. tbl_Customer
  2. CustomerID; Autonumber; PK
  3.  
  4. tbl_Location
  5. LocationID; Autonumber; PK
  6. CustomerID; Number; FK
  7.  
  8. tbl_Inventory
  9. InventoryID; PK
  10. LocationID; Number; FK
  11.  
Aug 8 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.