Question Database design - stock tracking

[Nic]

Hi,
Im planning my new DB and am contemplating the best design. It will be used for warehouse stock rotation and control of pallets. I want to track each pallet (product/time in/time out etc) to each pallet space within the warehouse. There are a total of 400 pallet spaces or 'locations' as i will refer to them as.
Now, would it be possible for me to have a table set up for each location? Will access object to having 400 tables in my data base?? Is there a limit?
Thoughts appreciated,

Many thanks,

 

[jdraw]

No objection to the number of Tables, but that is NOT how you would do the design.
You should research Normalization and Entity Relationship Diagramming before you go much further.

You may get some ideas here
http://www.databaseanswers.org/data_models/warehouse_inventory_management/index.htm

also see the first few topics here
http://www.rogersaccesslibrary.com/forum/topic238.html