J
jansenma
Hello,
I have a Many to Many relationship set up between the Region,
RegionContact, and ContactPoints tables, illustrated here:
http://img211.imageshack.us/img211/9838/relationships9lj.gif
When I include those three tables in a query and generate a form from
them, everything works great. Take a look at the form:
http://img300.imageshack.us/img300/7850/form4zt.gif
Every time I switch regions a new list of Contacts is pulled up. I
need this to happen on a second level, whenever I click on a contact
another subgroup of users appears (linked with a one to many to
ContactPoints table).
Can anyone help me figure out how to get this to work? When I try
adding the fields to a query I get a messed up form that I can't edit.
At first I had three one to many relationships and I had a form with
two subforms that worked like a charm. The problem was that I have
some ContactPoints that have multiple Regions and some Regions with
multiple Contact Points.
Thanks for any help!!
-Matt
I have a Many to Many relationship set up between the Region,
RegionContact, and ContactPoints tables, illustrated here:
http://img211.imageshack.us/img211/9838/relationships9lj.gif
When I include those three tables in a query and generate a form from
them, everything works great. Take a look at the form:
http://img300.imageshack.us/img300/7850/form4zt.gif
Every time I switch regions a new list of Contacts is pulled up. I
need this to happen on a second level, whenever I click on a contact
another subgroup of users appears (linked with a one to many to
ContactPoints table).
Can anyone help me figure out how to get this to work? When I try
adding the fields to a query I get a messed up form that I can't edit.
At first I had three one to many relationships and I had a form with
two subforms that worked like a charm. The problem was that I have
some ContactPoints that have multiple Regions and some Regions with
multiple Contact Points.
Thanks for any help!!
-Matt