Vendor Price Break relationships. This served as the core for the tool displayed in the following pane; it took all of 5 minutes to work out the relationships in my head and draw it out for the team to understand. It allows a vendor to have part based historical price breaks. If a purchase order for a specific vendor on a given part falls within a certain range, it looks up the correct price provided the quote hasn't expired.

Vendor & Part Management tool for purchasing department. Allows the user to assign multiple vendors, price breaks, expiration dates of quotes, and updates changes in vendor preference using script triggers. The script triggers modify a global key field which changes the relationship in each of the three middle panes.