I'm trying to filter records of one list by the selection from the other. The example is:
I have a Contract record. On the Contract record I added an Invoice list (related to Contract). Under the Invoice list I have a list of Invoice Items (related to Contract and to Invoice, each Invoice can have multiple Invoice Items).
I added a checkbox "Selected" on the Invoice and wanted to do it that way, that user clicks "Selected" on the Invoice and saves the record, and then the Invoice Item list is filtered by the Invoice, which has the Selected flag set to True. This doesn't work, system says the query failed, plus when I add "Selected" flag on Invoice Item list (from related invoice record) it's never selected (although on Invoice it is).
Do you have any other ideas on how to enable user to see on one page the invoice items for the invoice they select? I tried it with quick filter as well, but I cannot seem to make a filter to show only the invoices related to the opened contract.
Like