There is a powerful feature built into SFMs which allows you to filter a lookup according to fields on records related to the object you're looking up to. However, it is missing the ability to refer to header record fields which we could use to match on. We would use this feature more if it had the same functionality as other SFM features.
Use case for this would be to filter a large number of records on Covered Product lines first by Product Family using SFM Lookup Context Filtering, and then further filter the Products to show only those which have related records which match a key Covered Product field.
The power in this advanced filtering is to very quickly find records from objects with thousands of records without making the contract admin select from a lengthy list. For example, when I hard-code the value to match on, the lookup returns (2) records which is fantastic. But this is not workable as that value changes from Covered Product to Covered Product. When I remove the Advanced Lookup Filter, I get 50-100 records which have to be navigated though in the small SFM Lookup Screen.