July 16, 2008 at 10:52 am
Hello everyone
I have table within our database that stores all the text values for a series of dropdown boxes in our database. Depending on what you select in the first drop down box determines what you can select in the next. I am trying to build a report that will display the text values from each drop down. The table contains two fields one is a code which refers to the certain dropped down table and also a field which displays the the text. The problem I have is that once I have managed to obtain the first set of text I am unable to use the same field again as I have already defined it as a certain value. Is there a way I can rename the field for the first set of data, so I can use the field again to retrieve the next set of data?
__________________
July 16, 2008 at 11:27 am
I'm not sure I understand... are you trying to string together a series of parameters for a single report? For example, pick a country, then the region box fills with the appropriate regions, pick a region and the city box fills with the appropriate cities, select RUN and the report displays information for the selected country, region and city? If so, all you need to do is create a query for each dropdown box, with a parameter in the region query where clause that uses the country parameter and a parameter in the city query where clause that uses the region (and perhaps the country) parameter. Then set the report parameters to pull the valid data from each query.
Hope this helps!
Chad
July 16, 2008 at 1:46 pm
Sounds to me like a chained list - for each entry in Pulldown A, give me all possible choices from Pulldown B. Won't a nested double query work for this?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply