Multiple Link Child and Master Fields

[Yubin]

Hello, I'm new to the forums and I wasn't able to find anything in my searches so here we are.
I have a DB with a many-2-many relationship.
I have a form that has 3 comboboxes: Project #, Last Name, Active(Yes/No)
I have a subform that uses Project# as a Child and Master link.
I want to use all three exclusively to give the user the option to search using any ONE of the three, but when I add all three to the Child and Master link fields no reports show up unless all three fields match.
How do I set up the Link Child and Master Fields to read 1 OR 2 OR 3 instead of 1 AND 2 AND 3? I hope this makes since.

Thanks in advance.

[Rabbit]

Hello, I'm new to the forums and I wasn't able to find anything in my searches so here we are.
I have a DB with a many-2-many relationship.
I have a form that has 3 comboboxes: Project #, Last Name, Active(Yes/No)
I have a subform that uses Project# as a Child and Master link.
I want to use all three exclusively to give the user the option to search using any ONE of the three, but when I add all three to the Child and Master link fields no reports show up unless all three fields match.
How do I set up the Link Child and Master Fields to read 1 OR 2 OR 3 instead of 1 AND 2 AND 3? I hope this makes since.

Thanks in advance.

You should never have a many-to-many relationship. It causes too many design and functionality problems.

A master/child link doesn't work on an OR, only an AND. If you want to use OR, you're looking at VBA coding. You'll have to use the Filter and FilterOn property of the subform and the On Current event of the form and After Update events of the key fields. And more if you want cascading updates/deletes.