Hi Jenny,
Yep Cedar Point was fun for my 9 yr old daughter. She will ride anything.
Thank you for coming up with a good example. It took me awhile to understand, but I am still having some issues with the filter and understanding the concept.
I even modified it and only used one left join for the companytable to the companyindextable. Not as selective, but to modify it so I can understand it.
When I created my dynamic table for this recordset, it shows the 4 companies and option 1-4 with a number in it. The number 1-3 represents the option. Is the next step to setup variables to change the number to a string. I would rather have the name then the number.
thx
Mike D