It is currently Sun Dec 16, 2018 8:52 pm




Post new topic Reply to topic  [ 5 posts ] 
Tree-Wiew or Heirarchy 
Author Message

Joined: Thu Aug 07, 2008 12:39 pm
Posts: 69
Post Tree-Wiew or Heirarchy
Hello, all. I am having trouble figuring out how to build heirarchy into DBQ. I need a user to be able to select one site from a list and then examine items that are afilliated with only that site.

For example, you have a table that lists sites where people buy gasoline, and then anothertable of gasoline pumps at all your sites. How can a user select one site and then see the list of pumps filtered to see only the pumps located at the selected site?

It would mean passing the site number from one page to the next where it is used as a filter in the query that gets the pump data.

What would be really nice is a tree view kind of thing. has DBQ thought of oferring a tree view product or option?

Any input would be useful! Thanks in advance!

Chris


Wed Jan 05, 2011 11:17 pm
Profile E-mail

Joined: Fri Aug 22, 2008 1:03 pm
Posts: 94
Location: Australia
Post Re: Tree-Wiew or Heirarchy
Chris, have you looked at using categories?

_________________
www.conwave.com.au


Fri Jan 07, 2011 5:41 am
Profile E-mail WWW

Joined: Thu Aug 07, 2008 12:39 pm
Posts: 69
Post Re: Tree-Wiew or Heirarchy
Sorry, rgdobie, but you lost me. What do you mean by categories in this context?

Is this something in DBQS that I have missed? :?

Chris


Fri Jan 07, 2011 5:46 am
Profile E-mail

Joined: Fri Aug 22, 2008 1:03 pm
Posts: 94
Location: Australia
Post Re: Tree-Wiew or Heirarchy
If you use categories you can have a drop down list at the top of the page which allows you to filter. In your case it would show a list of filling stations (including All). The display below would show the pumps for the selected filling station.

e.g. Your main table is:
Pumps
------
PumpID
PumpName
StationID

Your secondary table is :
Stations
--------
StationID
StationName

_________________
www.conwave.com.au


Fri Jan 07, 2011 6:26 am
Profile E-mail WWW

Joined: Thu Aug 07, 2008 12:39 pm
Posts: 69
Post Re: Tree-Wiew or Heirarchy
Well, it looks like I have indeed missed something in DBQS! I am going to have to go looking for this. What I really need is a tree-view, because I have heirarchy like system, then company, then site, then pump (many levels deep). But this could help. I have just never tripped over anything about categories in DBQS. Guess I need to open my eyes! :-)

Thanks!

Chris


Fri Jan 07, 2011 6:41 am
Profile E-mail
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Copyright © 2004-2008 TheDevShop Ltd. All Rights Reserved