User friendly search page
What's the best way to filter records in a user friendly way ?
I have an object with details and lookups (simplified on this diagram).
Is there a more user-friendly way to filter ObjectSection records based on the lookupDetail value?
I thought of a workaround with a new object, then a detail in that new object that is filtered by a field above, but I don't know if this is the best way to do it. Because these are objects, it's clearly not a good way to filter records. I need these filters to be persistent for the logged in user, but several users will use this search "page" at the same time.
The global search is not a good solution either, I need to filter the records of a specific object according to the search values that are in the details of my object.
Do you have any idea how I can make this "search page"?