Another field is where the user enters the inventory level in Gallons.
I have a formula field for automatically computing the lbs of inventory (Gallons * Density) but the density varies depending on what Tank the user has selected in the Drop Down.
If Tank1 then Density = 1.2. If Tank2 then Density = 1.5 etc.