Look up Items in Different Tables
In our warehouse, we have rows of shelving with different items kept in different compartments. I would like to set up a form which uses variables to look up where the items are in the warehouse.
item: 2" plastic boxes
I would like the operator to put in the item on a form and then it searches the rows, shelves and finally the compartment to find the item.
I'm assuming I would need $row, $shelve and $compartment as variables. but how do I get these variables to go and look up (if that is the right term) in a different table:
Fields: ItemID, RowNo, ShelfNo, CompNo, ItemNo
I should also mention that the warehouse changes after an item is used up. Its more efficient and so an item doesn't always stay in the same place and therefore the reason for the look up.