Help on Table Design

[SF]

Hi,

I develop a small sale database for my friend that work quite smoothly. Now
my friend ask me to slightly modify this database to assign a sale person to
specific shelves so that inventory can be done (or print by Sale Person)
with specific location of the product. I comeup with adding two more tables
(tblEmployees and tblLocation) to the database.

tblEmployees
EmpID, EmpName...

tblLocation
LocationID, ShelveNo, RowNo, ColumnNo, EmpID

tblProducts
ProductID, ProductName, LocationID

It is quite difficult for me to decive on the location table since there are
many shelves and in each shelf, there are at least 3 rows and columns.

I would appreciate any suggextion on table design for this.

SF

 

[Lynn Trapp]

I think you are on the right track. I would add a combination Unique Index
on the ShelfNo, RowNo, and ColumnNo fields.