Subform linked to summary query?

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Here is what I am trying to do. Looking for suggestions.

We have a customer table, which includes territory, sales rep, and
customer type. This table is in bad shape due to lack af management.
Generally, a territory would have a couple of reps, and a couple of
customer types, but there are enough exceptions to that rule that there
is no way to really to automate the process. In order to create a tool
to make auditing this easier, I created a query which list all of the
unique combinations of these fields, and count the number of records
each has. This allows a fast scan to see that most of them are
correct, and which ones are likely to be wrong.

Now, I want to create a form based on that query, which will allow
someone to stroll though the summary, and on a subform, see record level
details of all items that match the summary record. All of this is
good, except for one thing.

My real life scenarios has 7 fields to match on, not three, but three is
the limit when I add the subform to the form. Any way around this?

Phil
 
Three is only a limit in the wizard, which you don't need to use.
Just enter your field names directly in the LinkMasterFields and
LinkChildFields of the subform control, separated by semicolons. Make sure
that they're in the same order in the two properties. My experience is that
this works best if the field names don't include any non-standard
characters.
 
Thanx. This is what I thought, abd tried, but it was not working right.
Now I think I have a better idea of what the issue is:

If there is a null value in any of the fields, it does not pick it up.

Any ideas?
 
Back
Top