Morning all

Question time. I have to use 2 resources related to each other, specifically tonnage of material and lorries used to transport them. Lorries may take more than one load per day, so the quantity transported by a lorry could vary as a multiple (20T/day, 40t/day, etc).

I have set up resources so that all items are work, not materials (there is a reason for this, as the programme is being used as a levelling and predictive tool as opposed to an actual planning one) and currently I need to input the amount of material, divide by the number of tonnes/ lorry, and use this as another resource- e.g. we need to move 600T of "stuff" and each lorry can make 3 runs a day. each lorry can carry 60t/day, so we need 10 lorries (600/60) in total. time i snot a factor as I have set resources to either fixed work or fixed units, depending on other factors.

Is it possible to link a resource to a resource so that the number of lorries could be set automatically, instead of a manual input? If I could set the divider (tones/lorry/day) it would be great, otherwise a single value would be fine- generally 40T works, and other values are less likely.

thanks in advance