Question
Dynamic data filters
Hi all. Small problem from a beginner.
I have several lists on a page populated by recordsets from a db server. All hunky-dorey with static filters. What I want to do is to filter the records for recordset #2 based on the user's selection from list # 1. For example "choose a country" and then "choose a region" where the region list / recordset is filtered by the country choice.
The SQL is no problem but I cannot find a way to have a variable for the query for recordset # 2 refer back to the current value in list # 1. Have reached the conclusion that a session variable may be the answer but don't know how to initialise it with the value from list # 1. Or perhaps I'm miles off!!
Any thoughts?
Thanks
Charles
I have several lists on a page populated by recordsets from a db server. All hunky-dorey with static filters. What I want to do is to filter the records for recordset #2 based on the user's selection from list # 1. For example "choose a country" and then "choose a region" where the region list / recordset is filtered by the country choice.
The SQL is no problem but I cannot find a way to have a variable for the query for recordset # 2 refer back to the current value in list # 1. Have reached the conclusion that a session variable may be the answer but don't know how to initialise it with the value from list # 1. Or perhaps I'm miles off!!
Any thoughts?
Thanks
Charles
