How to filter in this scenario?

  • I have a repeating group searching for Jobs.
  • A Job can have an invoice and/or a Quote, each of these has a status (Draft, Sent, Completed).

There is a dropdown for Invoices and Quotes, which ‘should’ enable the user to filter the repeating group. Example, when I select ‘Drafts’ from the Quotes dropdown, the Table should show all Jobs which have a Quote with status Drafts.

How can I filter like this?