Advanced Inventory Management

[blyxx86]

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.

[Rabbit]

So... each customer will only be related to one location right?

[blyxx86]

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.

[Rabbit]

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:

tbl_Customer
CustomerID; Autonumber; PK
 
tbl_Location
LocationID; Autonumber; PK
CustomerID; Number; FK
 
tbl_Inventory
InventoryID; PK
LocationID; Number; FK