Inventory Database

[pkfloyd]

I am looking to create a database which will keep track of a warehouse
inventory as well as inventory on sales trucks and track customer sales. Want
to link tables so that totals are linked when inventory is transferred to
trucks the warehouse inventory reflects this transfer. Also truck inventory
to reflect custormer sales. Any suggestions as to what type of tables, forms,
querys and relationships I should create would be helpfull. Thank you in
advance for your help.

[ruralguy via AccessMonster.com]

Maybe a Microsoft template would be the place to start.
http://office.microsoft.com/en-us/te...CT101426031033
pkfloyd wrote:

>I am looking to create a database which will keep track of a warehouse
inventory as well as inventory on sales trucks and track customer sales. Want
to link tables so that totals are linked when inventory is transferred to
trucks the warehouse inventory reflects this transfer. Also truck inventory
to reflect custormer sales. Any suggestions as to what type of tables, forms,
querys and relationships I should create would be helpfull. Thank you in
advance for your help.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200810/1

[Roger]

On Oct 6, 10:10*am, "pkfloyd" <u46723@uwewrote:

I am looking to create a database which will keep track of a warehouse
inventory as well as inventory on sales trucks and track customer sales. Want
to link tables so that totals are linked when inventory is transferred to
trucks the warehouse inventory reflects this transfer. Also truck inventory
to reflect custormer sales. Any suggestions as to what type of tables, forms,
querys and relationships I should create would be helpfull. Thank you in
advance for your help.

create tables
tblWarehouse
warehouseId
warehouse

tblInventory
itemId
description
cost
sellPrice
baseQty
etc

tblInventoryDetail
itemId
warehouseId
qtyOnHand
so tblWarehouse will be
1 main
2 truck 1

tblInventory will be stuff you buy and sell

when you create purchase and sales orders, on the detail table you
need to capture both the warehouseId and the itemId

and when you receive / ship goods, you update the qtyOnHand in
tblInventoryDetail accordingly

and then you'll need an inventory transfer function to move inventory
between warehouses