For example, our parent entity holds information for vehicles and acts as an invoice. The services on the vehicle are added in the sub entity. This lets us have multiple departments assign themselves and complete individual services on the same invoice.
We use a "List of Records by MySQL Query" to pull a list of the added services and display them in a list on the parent record (invoice). This field type doesn't have the option for filtering and not sure if it's possible to modify it to do so. See images below. I need to give our users a way to filter these. At the moment, the only thing I can think of is adding the sub entity to the main menu but that will have them jumping back & forth too much. I would like to keep it simple for them.