So here's a fun story: I've been working on a piece of scripting to calculate a freight charge on a specific sales order attributed to a shipping bill and attach it to a custom field on the sales order. This has involved a large number of shenanigans, including creating a direct relationship between a sales order and a bill via a drop down list on the sales order, the creation of a new form to handle bills with attributed bills of lading separate from other bills, and a rejected SQL search that got way too complicated for its own good.