Does anyone know of a way to link the length property of my piping parts to the weight column in the BOM?  I want it to display the weight for all other items, but the length for pipe runs.  Any advice would be very appreciated!