FP DBRW

J

jz

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.
 
J

jz

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
 
K

Kathleen Anderson

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
 
J

jz

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
 
J

jz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save as word to xml is splitting place holders ex: $abc.xyz$ 0
Error outlook.com 0xc0000005 trying to open custom controls 0
Grouping Names in Mail Merge 0
REINSTALLING MS OFFICE PRO PLUS 2019 0
Auto Populate One Pages from spreadsheet 0
Sharepoint not capturing staff name when automation runs 0
Outlook 365 Signatures 0
Auto populate value from one task to another in MS PROJECT 0

Top