I'm trying to create a database for shipping. We use two different size pallets 48x40x5 & 65x50x50, weighing 35lbs & 55lbs respectively. What I'm trying to do is input the various displays we send out and their corresponding LWH & weight to automatically calculate the total LWH & weight based on what is selected as well as how many is selected.
for example: I select 1 short pallet which is 48inches long by 40inches wide by 5 inches high that weighs 5lbs by itself. I select 1 display on the pallet that is 23 inches by 5 inches by 15 inches with a weight of 10lbs. Since the display is smaller than the pallet only the weight/height is affected. So when I select, it should show the total dims/weight as 48x40x20 with a weight of 50lbs (adding the height to the pallet/weight of both the pallet & display.)