I have a form(form1) with a button to another form(form2). I've set it up so that form2 has a filter so that form2 only shows those records with a FK field matching the PK of the data currently in form1.
The problem is:
I can only ever see ONE record in form2. I want the filter to show ALL rows of form2 where the fk matches the pk in form1.