Inventory Tracking how to auto generate specific locations in the warehouse for parts

[DMol15]

I want to compose a database that tracks incoming shipments when they come off the truck. I want the employees to be able to type/scan the part number into the incoming shipments form, and specify the company it came from along with other related information. I want to be able to auto generate a location for the coils based on the company entered into the form. This is where I am having trouble. For instance, I want to scan an incoming coil from US steel and designate it a section in the warehouse like G-10. So, say G-10 has 5 rows and each row can hold 10 coils. I want to be able to tell the worker with my database to put the coil into section G-10 row 1. Then, once row 1 is filled up to tell the worker to put it into G-10 row 2 and so on. Also, I want to be able to take those coils out of their designated locations when they are scanned into their next process. Like, when they go to their next process, say in house finishing they have been taken out of their spots, and show those spots open again. Say a coil in section G-10 row 1 has just been scanned in at in house finish, now that row is open again for another coil that comes from a shipment.

[ranman256]

we have a location table, marked on the floor of the warehouse.

[Micron]

You'd be better off storing the coil based on rack load, interference, obstacles, etc., then scanning it's location off of the rack label and inputting that? It shouldn't matter that they go into specific spots - especially adjacent ones. These weigh what - anywhere from 10k to 40k pounds? The idea of using a db to stipulate that one rack should hold 10 35k lb coils and another one should hold maybe 10 10k lb coils doesn't make sense to me. But it's your business so you can do what you want to I guess.