The primary identification is the Item #.  Ideally, someone creates an Item using the Item Creation Form, for examploe product number 1ST1066.  Each time it enters an area an employee checks the product in to the new area.   In my dreams, they open the Item Location Form, scan the 1ST1066 QR Code, which links to the Item Creation Form, and then choose from a drop down with the 8 available locations and submit.  

(Or even better, if I could create a form for each area of the factory floor.  They only need to open their specific floor, scan the QR code and press submit.  Because it is the "Inventory Form" the database automatically notes location for the item in database)

At any time, we can query a list of all the items on the floor and see the location of each.  

I've started playing around with Zoho Creator ...but would appreciate any advice how to best create the above.  

Thanks,

Dan