Hello,
I am trying to get the design correct for a system i am developing for a yard management control system at work have most of what i need i am confused on how to the following rule with a trailer
i have a design in place that allows me to book a lorry on to site with a trailer can be loaded / unloaded (Full or empty) i need to drop into a bay and collect another trailer and ether load something of empty something and can drop / swap and record what trailer a registration has left site with
so i need to record the following
Reg & Trailer on site do some moves Load/unload (can be both or just one or the other)
log registration & trailer off site and know what products (reference number assign to the trailer if not empty ) have been loaded onto that trailer just need a quick guide that i can fit into the rest of my design which can be altered to fit best practices.
AT the moment i have been able to book lorry in do something and book out that works fine i just don`t know how to assign a differnt load / unload routing to my desgin hope i am making sence
any help with this i know it must be a simple design problem i just can`t see it
Thanks in advance for anyone looking.
Paul....