Inventory

[Nemacol]

I have an inventory database.
The master sheet is a list of every item that they use including a column for each of the venues that are in use.
so the fields are:
item Name
Description
Measurement
vendor
vendor #
GL#
Barcode
Price
Stock Location (freezer, cooler, dry stock)
(now venues)
V1
V2
V3


Etc...

I talked about a way to do this different in another thread but decided it was easier to do it this way (esp since this is a temporary system)

So from this i do a query (something to the effect of)

Select * from tblMaster
where V1 IS NOT NULL
order by Stock Location ASC;

And this pulls a list of everything that venue 1 uses.

Now they are asking that i am able to order each section (freezer 10, cooler20, dry stock30) by selves and the order they are on the shelves.

To do this I am making another table called Itemization: (something to the effect of)
Stack A-Z (for each shelf tower)
Shelf A-Z (for each shelf on the tower)
Item A-Z (for a listing of items on a shelf)

So item 20CDE is an item in the cooler on the 3rd tower 4th shelf and 5th item over. I like the idea of letters because i can get to 26 with a single byte and there is never an isntance of more than 10 stacks per venue so this has a lot of scale-ability for this place.


What i am thinking is as they populate the table with 1st and 2nd round inventory they can... in the master sheet... add 20CDE under Venue1 and where ever else it is applicable and then ill be able to pull much the same way i am not. I think it will order correctly.

My problem is getting the cell to recognize that there are 4 different variables in one cell.

Thank you for reading. Any advice tips trick. should i go another way with this?

again, thank you.

[June7]

Four variables in one cell? Multi-value fields will give you headaches. You need a field for each value. It is always easier to concatenate than to split up. Your query can have multiple criteria for filtering and sorting.