|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
|
level, from STATE, to a deeper level that filters the results based upon the location id and id, which is the person's id. So, I have two tables, one for STATE and another with all kinds of user details. I created a query in ACCESS that pulls from both, using location ID and ID. I have tried with a relationship between the 2 tables, using location id and location id, as well as location id and id. Neither worked, so right now I have no relationships. SO...do I need to set a filter on the final results page, and/or what about how I how I have the state links hyperlinking to the results page? I link to the results asp, then add 2 parameters, as you can see...one for location id, one for id. It looks liek it should just give me results for id's with 1, then when I click the next state, show me results with location id and id for 2...but it shows all, as you can see. Any ideas? It seems to be close, but can't get it. Thanks so much for nay feedback. How to filter a database query using two drop down lists....
http://www.spiderwebwoman.com/tutorials/doubledropdown.htm -- Show quoteHide quote~ Kathleen Anderson Microsoft MVP - FrontPage Spider Web Woman Designs Expression Web Resources: http://www.spiderwebwoman.com/xweb/ Expression Web Wiki: http://expression-web-wiki.com/ FrontPage Resources: http://www.spiderwebwoman.com/resources/ Please reply to the newsgroup for the benefit of others "jz" <j*@discussions.microsoft.com> wrote in message news:ED9F87EA-A049-4BE0-9500-499482205966@microsoft.com... > Hi. I am having a hard time filtering results. I'm trying to drill down > one > level, from STATE, to a deeper level that filters the results based upon > the > location id and id, which is the person's id. > > So, I have two tables, one for STATE and another with all kinds of user > details. I created a query in ACCESS that pulls from both, using location > ID > and ID. > > I have tried with a relationship between the 2 tables, using location id > and > location id, as well as location id and id. Neither worked, so right now > I > have no relationships. > > SO...do I need to set a filter on the final results page, and/or what > about > how I how I have the state links hyperlinking to the results page? I link > to > the results asp, then add 2 parameters, as you can see...one for location > id, > one for id. It looks liek it should just give me results for id's with 1, > then when I click the next state, show me results with location id and id > for > 2...but it shows all, as you can see. > > Any ideas? It seems to be close, but can't get it. > > Thanks so much for nay feedback. Thanks, Kathleen. I recall you helping me so many years ago with
weltman.com. It was hand-coded after I left, but we had most of it licked with your help! Kathleen...I was hoping to do this without any dropdowns. Is it possible to just present result sets without user interaction...aside from them clicking the hyperlinked db field that I am presenting on the first results page, or no? Thanks so much, once again. -jz Show quoteHide quote "Kathleen Anderson" wrote: > How to filter a database query using two drop down lists.... > http://www.spiderwebwoman.com/tutorials/doubledropdown.htm > > -- > > ~ Kathleen Anderson > Microsoft MVP - FrontPage > Spider Web Woman Designs > Expression Web Resources: http://www.spiderwebwoman.com/xweb/ > Expression Web Wiki: http://expression-web-wiki.com/ > FrontPage Resources: http://www.spiderwebwoman.com/resources/ > Please reply to the newsgroup for the benefit of others > > > "jz" <j*@discussions.microsoft.com> wrote in message > news:ED9F87EA-A049-4BE0-9500-499482205966@microsoft.com... > > Hi. I am having a hard time filtering results. I'm trying to drill down > > one > > level, from STATE, to a deeper level that filters the results based upon > > the > > location id and id, which is the person's id. > > > > So, I have two tables, one for STATE and another with all kinds of user > > details. I created a query in ACCESS that pulls from both, using location > > ID > > and ID. > > > > I have tried with a relationship between the 2 tables, using location id > > and > > location id, as well as location id and id. Neither worked, so right now > > I > > have no relationships. > > > > SO...do I need to set a filter on the final results page, and/or what > > about > > how I how I have the state links hyperlinking to the results page? I link > > to > > the results asp, then add 2 parameters, as you can see...one for location > > id, > > one for id. It looks liek it should just give me results for id's with 1, > > then when I click the next state, show me results with location id and id > > for > > 2...but it shows all, as you can see. > > > > Any ideas? It seems to be close, but can't get it. > > > > Thanks so much for nay feedback. > > > This is the only other thing I can think of: How to create a "Pick List"
page and generate a detail page http://www.spiderwebwoman.com/tutorials/picklist.htm if that doesn't help, review the links on this page: http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp to see if there's anything there that will help. -- Show quoteHide quote~ Kathleen Anderson Microsoft MVP - FrontPage Spider Web Woman Designs Expression Web Resources: http://www.spiderwebwoman.com/xweb/ Expression Web Wiki: http://expression-web-wiki.com/ FrontPage Resources: http://www.spiderwebwoman.com/resources/ Please reply to the newsgroup for the benefit of others "jz" <j*@discussions.microsoft.com> wrote in message news:E52C9339-89B2-43DF-8A13-C17676943D1E@microsoft.com... > Thanks, Kathleen. I recall you helping me so many years ago with > weltman.com. It was hand-coded after I left, but we had most of it licked > with your help! > > Kathleen...I was hoping to do this without any dropdowns. Is it possible > to > just present result sets without user interaction...aside from them > clicking > the hyperlinked db field that I am presenting on the first results page, > or > no? > > Thanks so much, once again. -jz > > "Kathleen Anderson" wrote: > >> How to filter a database query using two drop down lists.... >> http://www.spiderwebwoman.com/tutorials/doubledropdown.htm >> >> -- >> >> ~ Kathleen Anderson >> Microsoft MVP - FrontPage >> Spider Web Woman Designs >> Expression Web Resources: http://www.spiderwebwoman.com/xweb/ >> Expression Web Wiki: http://expression-web-wiki.com/ >> FrontPage Resources: http://www.spiderwebwoman.com/resources/ >> Please reply to the newsgroup for the benefit of others >> >> >> "jz" <j*@discussions.microsoft.com> wrote in message >> news:ED9F87EA-A049-4BE0-9500-499482205966@microsoft.com... >> > Hi. I am having a hard time filtering results. I'm trying to drill >> > down >> > one >> > level, from STATE, to a deeper level that filters the results based >> > upon >> > the >> > location id and id, which is the person's id. >> > >> > So, I have two tables, one for STATE and another with all kinds of user >> > details. I created a query in ACCESS that pulls from both, using >> > location >> > ID >> > and ID. >> > >> > I have tried with a relationship between the 2 tables, using location >> > id >> > and >> > location id, as well as location id and id. Neither worked, so right >> > now >> > I >> > have no relationships. >> > >> > SO...do I need to set a filter on the final results page, and/or what >> > about >> > how I how I have the state links hyperlinking to the results page? I >> > link >> > to >> > the results asp, then add 2 parameters, as you can see...one for >> > location >> > id, >> > one for id. It looks liek it should just give me results for id's with >> > 1, >> > then when I click the next state, show me results with location id and >> > id >> > for >> > 2...but it shows all, as you can see. >> > >> > Any ideas? It seems to be close, but can't get it. >> > >> > Thanks so much for nay feedback. >> >> >> I'll give it a look. Thanks so much, Kathleen! Nice to be back in touch.
-jz Show quoteHide quote "Kathleen Anderson" wrote: > This is the only other thing I can think of: How to create a "Pick List" > page and generate a detail page > http://www.spiderwebwoman.com/tutorials/picklist.htm if that doesn't help, > review the links on this page: > http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp to see if > there's anything there that will help. > > -- > > ~ Kathleen Anderson > Microsoft MVP - FrontPage > Spider Web Woman Designs > Expression Web Resources: http://www.spiderwebwoman.com/xweb/ > Expression Web Wiki: http://expression-web-wiki.com/ > FrontPage Resources: http://www.spiderwebwoman.com/resources/ > Please reply to the newsgroup for the benefit of others > > > "jz" <j*@discussions.microsoft.com> wrote in message > news:E52C9339-89B2-43DF-8A13-C17676943D1E@microsoft.com... > > Thanks, Kathleen. I recall you helping me so many years ago with > > weltman.com. It was hand-coded after I left, but we had most of it licked > > with your help! > > > > Kathleen...I was hoping to do this without any dropdowns. Is it possible > > to > > just present result sets without user interaction...aside from them > > clicking > > the hyperlinked db field that I am presenting on the first results page, > > or > > no? > > > > Thanks so much, once again. -jz > > > > "Kathleen Anderson" wrote: > > > >> How to filter a database query using two drop down lists.... > >> http://www.spiderwebwoman.com/tutorials/doubledropdown.htm > >> > >> -- > >> > >> ~ Kathleen Anderson > >> Microsoft MVP - FrontPage > >> Spider Web Woman Designs > >> Expression Web Resources: http://www.spiderwebwoman.com/xweb/ > >> Expression Web Wiki: http://expression-web-wiki.com/ > >> FrontPage Resources: http://www.spiderwebwoman.com/resources/ > >> Please reply to the newsgroup for the benefit of others > >> > >> > >> "jz" <j*@discussions.microsoft.com> wrote in message > >> news:ED9F87EA-A049-4BE0-9500-499482205966@microsoft.com... > >> > Hi. I am having a hard time filtering results. I'm trying to drill > >> > down > >> > one > >> > level, from STATE, to a deeper level that filters the results based > >> > upon > >> > the > >> > location id and id, which is the person's id. > >> > > >> > So, I have two tables, one for STATE and another with all kinds of user > >> > details. I created a query in ACCESS that pulls from both, using > >> > location > >> > ID > >> > and ID. > >> > > >> > I have tried with a relationship between the 2 tables, using location > >> > id > >> > and > >> > location id, as well as location id and id. Neither worked, so right > >> > now > >> > I > >> > have no relationships. > >> > > >> > SO...do I need to set a filter on the final results page, and/or what > >> > about > >> > how I how I have the state links hyperlinking to the results page? I > >> > link > >> > to > >> > the results asp, then add 2 parameters, as you can see...one for > >> > location > >> > id, > >> > one for id. It looks liek it should just give me results for id's with > >> > 1, > >> > then when I click the next state, show me results with location id and > >> > id > >> > for > >> > 2...but it shows all, as you can see. > >> > > >> > Any ideas? It seems to be close, but can't get it. > >> > > >> > Thanks so much for nay feedback. > >> > >> > >> > > > OK, I LIKE WHAT I get in my head from setting this up, but it's not
displaying things now. So, just curious...do i need to link up my access tables via relationship or query to share the common location id...the primary key? Thanks for any feedback. If you don't know, it's fine. I'm just wondering. Thx. -jz Show quoteHide quote "Kathleen Anderson" wrote: > This is the only other thing I can think of: How to create a "Pick List" > page and generate a detail page > http://www.spiderwebwoman.com/tutorials/picklist.htm if that doesn't help, > review the links on this page: > http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp to see if > there's anything there that will help. > > -- > > ~ Kathleen Anderson > Microsoft MVP - FrontPage > Spider Web Woman Designs > Expression Web Resources: http://www.spiderwebwoman.com/xweb/ > Expression Web Wiki: http://expression-web-wiki.com/ > FrontPage Resources: http://www.spiderwebwoman.com/resources/ > Please reply to the newsgroup for the benefit of others > > > "jz" <j*@discussions.microsoft.com> wrote in message > news:E52C9339-89B2-43DF-8A13-C17676943D1E@microsoft.com... > > Thanks, Kathleen. I recall you helping me so many years ago with > > weltman.com. It was hand-coded after I left, but we had most of it licked > > with your help! > > > > Kathleen...I was hoping to do this without any dropdowns. Is it possible > > to > > just present result sets without user interaction...aside from them > > clicking > > the hyperlinked db field that I am presenting on the first results page, > > or > > no? > > > > Thanks so much, once again. -jz > > > > "Kathleen Anderson" wrote: > > > >> How to filter a database query using two drop down lists.... > >> http://www.spiderwebwoman.com/tutorials/doubledropdown.htm > >> > >> -- > >> > >> ~ Kathleen Anderson > >> Microsoft MVP - FrontPage > >> Spider Web Woman Designs > >> Expression Web Resources: http://www.spiderwebwoman.com/xweb/ > >> Expression Web Wiki: http://expression-web-wiki.com/ > >> FrontPage Resources: http://www.spiderwebwoman.com/resources/ > >> Please reply to the newsgroup for the benefit of others > >> > >> > >> "jz" <j*@discussions.microsoft.com> wrote in message > >> news:ED9F87EA-A049-4BE0-9500-499482205966@microsoft.com... > >> > Hi. I am having a hard time filtering results. I'm trying to drill > >> > down > >> > one > >> > level, from STATE, to a deeper level that filters the results based > >> > upon > >> > the > >> > location id and id, which is the person's id. > >> > > >> > So, I have two tables, one for STATE and another with all kinds of user > >> > details. I created a query in ACCESS that pulls from both, using > >> > location > >> > ID > >> > and ID. > >> > > >> > I have tried with a relationship between the 2 tables, using location > >> > id > >> > and > >> > location id, as well as location id and id. Neither worked, so right > >> > now > >> > I > >> > have no relationships. > >> > > >> > SO...do I need to set a filter on the final results page, and/or what > >> > about > >> > how I how I have the state links hyperlinking to the results page? I > >> > link > >> > to > >> > the results asp, then add 2 parameters, as you can see...one for > >> > location > >> > id, > >> > one for id. It looks liek it should just give me results for id's with > >> > 1, > >> > then when I click the next state, show me results with location id and > >> > id > >> > for > >> > 2...but it shows all, as you can see. > >> > > >> > Any ideas? It seems to be close, but can't get it. > >> > > >> > Thanks so much for nay feedback. > >> > >> > >> > > > Please disregard...I'm golden, thanks to your direction, Kathleen.
I started with some fresh pages and it works now. I love breakthroughs...12 hours later, makes it much sweeter. Hopefully, 10 more years doesn't pass, wait...7, before I use it, again. PTL, jz. Show quoteHide quote "Kathleen Anderson" wrote: > This is the only other thing I can think of: How to create a "Pick List" > page and generate a detail page > http://www.spiderwebwoman.com/tutorials/picklist.htm if that doesn't help, > review the links on this page: > http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp to see if > there's anything there that will help. > > -- > > ~ Kathleen Anderson > Microsoft MVP - FrontPage > Spider Web Woman Designs > Expression Web Resources: http://www.spiderwebwoman.com/xweb/ > Expression Web Wiki: http://expression-web-wiki.com/ > FrontPage Resources: http://www.spiderwebwoman.com/resources/ > Please reply to the newsgroup for the benefit of others > > > "jz" <j*@discussions.microsoft.com> wrote in message > news:E52C9339-89B2-43DF-8A13-C17676943D1E@microsoft.com... > > Thanks, Kathleen. I recall you helping me so many years ago with > > weltman.com. It was hand-coded after I left, but we had most of it licked > > with your help! > > > > Kathleen...I was hoping to do this without any dropdowns. Is it possible > > to > > just present result sets without user interaction...aside from them > > clicking > > the hyperlinked db field that I am presenting on the first results page, > > or > > no? > > > > Thanks so much, once again. -jz > > > > "Kathleen Anderson" wrote: > > > >> How to filter a database query using two drop down lists.... > >> http://www.spiderwebwoman.com/tutorials/doubledropdown.htm > >> > >> -- > >> > >> ~ Kathleen Anderson > >> Microsoft MVP - FrontPage > >> Spider Web Woman Designs > >> Expression Web Resources: http://www.spiderwebwoman.com/xweb/ > >> Expression Web Wiki: http://expression-web-wiki.com/ > >> FrontPage Resources: http://www.spiderwebwoman.com/resources/ > >> Please reply to the newsgroup for the benefit of others > >> > >> > >> "jz" <j*@discussions.microsoft.com> wrote in message > >> news:ED9F87EA-A049-4BE0-9500-499482205966@microsoft.com... > >> > Hi. I am having a hard time filtering results. I'm trying to drill > >> > down > >> > one > >> > level, from STATE, to a deeper level that filters the results based > >> > upon > >> > the > >> > location id and id, which is the person's id. > >> > > >> > So, I have two tables, one for STATE and another with all kinds of user > >> > details. I created a query in ACCESS that pulls from both, using > >> > location > >> > ID > >> > and ID. > >> > > >> > I have tried with a relationship between the 2 tables, using location > >> > id > >> > and > >> > location id, as well as location id and id. Neither worked, so right > >> > now > >> > I > >> > have no relationships. > >> > > >> > SO...do I need to set a filter on the final results page, and/or what > >> > about > >> > how I how I have the state links hyperlinking to the results page? I > >> > link > >> > to > >> > the results asp, then add 2 parameters, as you can see...one for > >> > location > >> > id, > >> > one for id. It looks liek it should just give me results for id's with > >> > 1, > >> > then when I click the next state, show me results with location id and > >> > id > >> > for > >> > 2...but it shows all, as you can see. > >> > > >> > Any ideas? It seems to be close, but can't get it. > >> > > >> > Thanks so much for nay feedback. > >> > >> > >> > > > I'm glad I could help!
-- Show quoteHide quote~ Kathleen Anderson Microsoft MVP - FrontPage Spider Web Woman Designs Expression Web Resources: http://www.spiderwebwoman.com/xweb/ Expression Web Wiki: http://expression-web-wiki.com/ FrontPage Resources: http://www.spiderwebwoman.com/resources/ Please reply to the newsgroup for the benefit of others "jz" <j*@discussions.microsoft.com> wrote in message news:DC9CE74E-1BB6-4A90-BB52-09A7BC39B6C6@microsoft.com... > Please disregard...I'm golden, thanks to your direction, Kathleen. > > I started with some fresh pages and it works now. I love > breakthroughs...12 > hours later, makes it much sweeter. > > Hopefully, 10 more years doesn't pass, wait...7, before I use it, again. > > PTL, jz. > > "Kathleen Anderson" wrote: > >> This is the only other thing I can think of: How to create a "Pick List" >> page and generate a detail page >> http://www.spiderwebwoman.com/tutorials/picklist.htm if that doesn't >> help, >> review the links on this page: >> http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp to see if >> there's anything there that will help. >> >> -- >> >> ~ Kathleen Anderson >> Microsoft MVP - FrontPage >> Spider Web Woman Designs >> Expression Web Resources: http://www.spiderwebwoman.com/xweb/ >> Expression Web Wiki: http://expression-web-wiki.com/ >> FrontPage Resources: http://www.spiderwebwoman.com/resources/ >> Please reply to the newsgroup for the benefit of others >> >> >> "jz" <j*@discussions.microsoft.com> wrote in message >> news:E52C9339-89B2-43DF-8A13-C17676943D1E@microsoft.com... >> > Thanks, Kathleen. I recall you helping me so many years ago with >> > weltman.com. It was hand-coded after I left, but we had most of it >> > licked >> > with your help! >> > >> > Kathleen...I was hoping to do this without any dropdowns. Is it >> > possible >> > to >> > just present result sets without user interaction...aside from them >> > clicking >> > the hyperlinked db field that I am presenting on the first results >> > page, >> > or >> > no? >> > >> > Thanks so much, once again. -jz >> > >> > "Kathleen Anderson" wrote: >> > >> >> How to filter a database query using two drop down lists.... >> >> http://www.spiderwebwoman.com/tutorials/doubledropdown.htm >> >> >> >> -- >> >> >> >> ~ Kathleen Anderson >> >> Microsoft MVP - FrontPage >> >> Spider Web Woman Designs >> >> Expression Web Resources: http://www.spiderwebwoman.com/xweb/ >> >> Expression Web Wiki: http://expression-web-wiki.com/ >> >> FrontPage Resources: http://www.spiderwebwoman.com/resources/ >> >> Please reply to the newsgroup for the benefit of others >> >> >> >> >> >> "jz" <j*@discussions.microsoft.com> wrote in message >> >> news:ED9F87EA-A049-4BE0-9500-499482205966@microsoft.com... >> >> > Hi. I am having a hard time filtering results. I'm trying to drill >> >> > down >> >> > one >> >> > level, from STATE, to a deeper level that filters the results based >> >> > upon >> >> > the >> >> > location id and id, which is the person's id. >> >> > >> >> > So, I have two tables, one for STATE and another with all kinds of >> >> > user >> >> > details. I created a query in ACCESS that pulls from both, using >> >> > location >> >> > ID >> >> > and ID. >> >> > >> >> > I have tried with a relationship between the 2 tables, using >> >> > location >> >> > id >> >> > and >> >> > location id, as well as location id and id. Neither worked, so >> >> > right >> >> > now >> >> > I >> >> > have no relationships. >> >> > >> >> > SO...do I need to set a filter on the final results page, and/or >> >> > what >> >> > about >> >> > how I how I have the state links hyperlinking to the results page? >> >> > I >> >> > link >> >> > to >> >> > the results asp, then add 2 parameters, as you can see...one for >> >> > location >> >> > id, >> >> > one for id. It looks liek it should just give me results for id's >> >> > with >> >> > 1, >> >> > then when I click the next state, show me results with location id >> >> > and >> >> > id >> >> > for >> >> > 2...but it shows all, as you can see. >> >> > >> >> > Any ideas? It seems to be close, but can't get it. >> >> > >> >> > Thanks so much for nay feedback. >> >> >> >> >> >> >> >> >>  |
|||||||||||||||||||||||
Other interesting topics