469,648 Members | 1,669 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,648 developers. It's quick & easy.

Multiple Link Child and Master Fields

1
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.
Oct 25 '07 #1
1 7473
Rabbit
12,516 Expert Mod 8TB
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.
Oct 25 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Roy Adams | last post: by
6 posts views Thread by JC | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.