Cascading Query ( I think)

[cgemmill1]

My end goal is to create a form with a line chart. A person would select the organization and then the data indicator.

I thought by creating two queries, one with organization name and the other with the data indicator fields. I had thought if you selected organization first, I would only see data for the organization I chose but this is not the case.

How can I use a query to select an organizatrion and then only the data that pertains to that organization.

 

[pbaldy]

It sounds like you're trying to do this:

http://www.baldyweb.com/CascadingCombo.htm

 

[wilpeter]

By some chance, is your website down at present? Can't access either the database or your main site. Cheers!

 

[pbaldy]

No, it appears to be up. Here's the page and the file in case you're getting blocked:

 

[cgemmill1]

Will this work with charting?

 

[pbaldy]

I don't do much charting, but I would think it would work if the chart was based on a query using the combo(s).