I have two forms, one is report and a form called persons. Each report could be linked to more than a single person using a lookup multi-select in the form.
Now I want to fetch all reports linked to a certain person provided that each person field int he report form most probably contains more than a single person (a list of persons).
How to do this without iterating through the whole database of reports then iterate each list of persons?