CJ Wiley
|
| Posted: 02/03/2004, 10:39 AM |
|
A multilevel database?
A form that has a PARENT-CHILD relationship? Such as PARENT displayed at the top of the file and the CHILD records displayed in a grid below.
Thanks!
CJ
|
|
|
 |
DonB
|
| Posted: 02/03/2004, 11:14 AM |
|
Look at the Directory and Path controls, in combination with a Grid it would
do what you are asking to do.
--
DonB
http://www.gotodon.com/ccbth
<CJWiley@forum.codecharge (CJ Wiley)> wrote in message
news:6401feac5b085c@news.codecharge.com...
> A multilevel database?
>
> A form that has a PARENT-CHILD relationship? Such as PARENT displayed at
the top of the file and the CHILD records displayed in a grid below.
>
>
> Thanks!
> CJ
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
CJ Wiley
|
| Posted: 02/04/2004, 1:54 PM |
|
DonB thank you for your response. I'm not sure I quite understand what you written. I am very new to this.
Peter R. indicated that there are no limitations on how many parent/child database levels can be handled.
I would like to see a working example so that I can see it can be done. If it can't be done then I may not want to spend the money/time on this product at this time.
CJ
|
|
|
|
peterr
Posts: 5971
|
| Posted: 02/04/2004, 2:01 PM |
|
Hmm, I'm not sure which of my postings are you referring to but I guess the number or levels shouldn't play a role here. They key is to pass the parent record ID from one Grid to another.
Therefore if you create 2 Grids, one for your parent records and second one for child records, then in the 1st Grid you will need to create a link that points to the same page and passes the parent ID so that the 2nd Grid can use it. This can be done by specifying "Link Parameters" in the "Href Source" property of your Link.
Finally, in the 2nd Grid's Data Source property specify that you want your Grid to use the parameter from the 1st Grid and show only those matching records. A sample Grid parameter configuration is shown here:
http://docs.codecharge.com/studio/html/QuickStart/Creat...tWhereProp.html
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
DonB
|
| Posted: 02/04/2004, 2:02 PM |
|
There is an examplepack page that illustrates this. The controls are driven
by a recursive database relation (there is a perent foreign key which
references the primary key of the same table. So the only limit on levels
is the ability to store the key value - or about 2147483648 items.
Look for the example called Directory & Path Implementation
It can be done - I have done it, as have many others. To be clear, it shows
two levels at any given time - the parent and the child - not the entire
hierarchy like you would see with a "tree" control.
The CodeCharge Studio Directory control is essentially what you would see in
Yahoo's "Web Site Directory" - in both function and in it's appearance.
--
DonB
http://www.gotodon.com/ccbth
<CJWiley@forum.codecharge (CJ Wiley)> wrote in message
news:640216a02165c5@news.codecharge.com...
> DonB thank you for your response. I'm not sure I quite understand what
you written. I am very new to this.
>
> Peter R. indicated that there are no limitations on how many parent/child
database levels can be handled.
>
> I would like to see a working example so that I can see it can be done.
If it can't be done then I may not want to spend the money/time on this
product at this time.
>
>
> CJ
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Don Safar
|
| Posted: 02/04/2004, 2:24 PM |
|
I've used the directory builder control on a website I developed in PHP, but
should work the same in ASP. You can see it in action at
http://www.cool-offers.com. If you want to see multiple children tied to the
same parent, visit my website http://www.insights-web.com and click on the
sample applications )menu on the left side). When you get to the sample
site, click on view scripts and then organizational planner (which is a work
in progress). Login as the default user and select contact list, then the
first contact in the list. You will see 4 child tables tied to the same
parent.
Don Safar
http://www.insights-web.com
http://www.cool-offers.com
<CJWiley@forum.codecharge (CJ Wiley)> wrote in message
news:6401feac5b085c@news.codecharge.com...
> A multilevel database?
>
> A form that has a PARENT-CHILD relationship? Such as PARENT displayed at
the top of the file and the CHILD records displayed in a grid below.
>
>
> Thanks!
> CJ
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Nicole
Posts: 586
|
| Posted: 02/05/2004, 5:29 AM |
|
Hello,
I think you can create master-detail grid, like described in the KB articles
http://support.codecharge.com/kb_article.asp?article_id=46
http://support.codecharge.com/kb_article.asp?article_id=66
Quote CJ Wiley:
A multilevel database?
A form that has a PARENT-CHILD relationship? Such as PARENT displayed at the top of the file and the CHILD records displayed in a grid below.
Thanks!
CJ
_________________
Regards,
Nicole |
|
|
|
