Rookie
|
Posted: 11/12/2003, 6:58 AM |
|
I have 2 forms in a page, the page filter data based in a url parameter, but
the page displays data like this:
Form1.1
Form1.2
Form1.3
Form1.4
Form2.1
Form2.2
Form2.3
Form2.4
but i need this:
Form1.1
Form2.1
Form1.2
Form2.2
Form1.3
Form2.3
it can be done?
|
|
|
DonB
|
Posted: 11/12/2003, 9:33 AM |
|
Hello Will,
The "master-detail" aspect is not clear in your example. The thing to the
right of the decimal is the "master" and the thing to the left is the
"detail"?
Seems like you would want a grid at the top of the page with the
".1,.2,.3,.4" master records listed and each one having a link with this
value (to the same page) would do it. Just add detail form1 and detail
form2 below the grid and set their datasources to receive the URL parameter
from the link. Then, clicking a link in the grid would list the two detail
data sets for whatever you clicked.
--
DonB
http://www.gotodon.com/ccbth
"Rookie" <pcboss1976@hotmail.com> wrote in message
news:bothrg$636$1@news.codecharge.com...
> I have 2 forms in a page, the page filter data based in a url parameter,
but
> the page displays data like this:
>
> Form1.1
> Form1.2
> Form1.3
> Form1.4
>
> Form2.1
> Form2.2
> Form2.3
> Form2.4
>
> but i need this:
>
> Form1.1
> Form2.1
>
> Form1.2
> Form2.2
>
> Form1.3
> Form2.3
>
> it can be done?
>
>
|
|
|
rookie
|
Posted: 11/13/2003, 10:14 AM |
|
You're rigth, it's doesnt clear....it's something like this:
I have a search form, based in the class field, a class have many students,
I need to display the classes detail and the student's details, search works
fine, but it shows this:
class office2000
class vb
class foxpro
students of office2000
students of vb
students of foxpro
--------and I need this
class office2000
students of office2000
class vb
students of vb
class foxpro
students of foxpro
isnt really a master -detail page, there're two form that receive the same
parameter (s_class) from the search form.
I'm using CCS & ACCESS
in CCS the form are like this:
CLASSESS_FORM
STUDENTS_FORM
we just buy CCS becaus im a newbie in this, and it works so fine, that my
boss doesnt stop asking for new and "harder to do" things...
thanks in advanced...
"DonB" <~ccbth~@gotodon.com> wrote in message
news:botqss$gq0$1@news.codecharge.com...
> Hello Will,
>
> The "master-detail" aspect is not clear in your example. The thing to the
> right of the decimal is the "master" and the thing to the left is the
> "detail"?
>
> Seems like you would want a grid at the top of the page with the
> ".1,.2,.3,.4" master records listed and each one having a link with this
> value (to the same page) would do it. Just add detail form1 and detail
> form2 below the grid and set their datasources to receive the URL
parameter
> from the link. Then, clicking a link in the grid would list the two
detail
> data sets for whatever you clicked.
>
> --
> DonB
>
> http://www.gotodon.com/ccbth
>
>
> "Rookie" <pcboss1976@hotmail.com> wrote in message
>news:bothrg$636$1@news.codecharge.com...
> > I have 2 forms in a page, the page filter data based in a url parameter,
> but
> > the page displays data like this:
> >
> > Form1.1
> > Form1.2
> > Form1.3
> > Form1.4
> >
> > Form2.1
> > Form2.2
> > Form2.3
> > Form2.4
> >
> > but i need this:
> >
> > Form1.1
> > Form2.1
> >
> > Form1.2
> > Form2.2
> >
> > Form1.3
> > Form2.3
> >
> > it can be done?
> >
> >
>
>
|
|
|
DonB
|
Posted: 11/13/2003, 11:53 AM |
|
To do what you describe, you will need to define a query that returns the
following columns:
classname, studentname, <other class or student columns if needed>
You need a query that performs a SQL join between the Class table and the
Student table to get the results shown above. You should also sort the
query results by (classname, studentname) in that sequence.
Now you can put the results into an ordinary grid to get the output you
requested.
You can enhance the appearance by hiding the classname when there are
duplicates. All you have to do is put a small amount of code into the
BeforeShowRow event. For the details on how to do this, search for "Simple
Report with Groups" in the CCS help file. There is a very good example shown
there on how to do this.
--
DonB
http://www.gotodon.com/ccbth
"rookie" <pcboss1976@hotmail.com> wrote in message
news:bp0hmv$ksv$1@news.codecharge.com...
> You're rigth, it's doesnt clear....it's something like this:
> I have a search form, based in the class field, a class have many
students,
> I need to display the classes detail and the student's details, search
works
> fine, but it shows this:
>
> class office2000
> class vb
> class foxpro
> students of office2000
> students of vb
> students of foxpro
> --------and I need this
> class office2000
> students of office2000
> class vb
> students of vb
> class foxpro
> students of foxpro
>
> isnt really a master -detail page, there're two form that receive the same
> parameter (s_class) from the search form.
> I'm using CCS & ACCESS
> in CCS the form are like this:
>
> CLASSESS_FORM
> STUDENTS_FORM
>
> we just buy CCS becaus im a newbie in this, and it works so fine, that my
> boss doesnt stop asking for new and "harder to do" things...
> thanks in advanced...
>
>
> "DonB" <~ccbth~@gotodon.com> wrote in message
>news:botqss$gq0$1@news.codecharge.com...
> > Hello Will,
> >
> > The "master-detail" aspect is not clear in your example. The thing to
the
> > right of the decimal is the "master" and the thing to the left is the
> > "detail"?
> >
> > Seems like you would want a grid at the top of the page with the
> > ".1,.2,.3,.4" master records listed and each one having a link with this
> > value (to the same page) would do it. Just add detail form1 and detail
> > form2 below the grid and set their datasources to receive the URL
> parameter
> > from the link. Then, clicking a link in the grid would list the two
> detail
> > data sets for whatever you clicked.
> >
> > --
> > DonB
> >
> > http://www.gotodon.com/ccbth
> >
> >
> > "Rookie" <pcboss1976@hotmail.com> wrote in message
> >news:bothrg$636$1@news.codecharge.com...
> > > I have 2 forms in a page, the page filter data based in a url
parameter,
> > but
> > > the page displays data like this:
> > >
> > > Form1.1
> > > Form1.2
> > > Form1.3
> > > Form1.4
> > >
> > > Form2.1
> > > Form2.2
> > > Form2.3
> > > Form2.4
> > >
> > > but i need this:
> > >
> > > Form1.1
> > > Form2.1
> > >
> > > Form1.2
> > > Form2.2
> > >
> > > Form1.3
> > > Form2.3
> > >
> > > it can be done?
> > >
> > >
> >
> >
>
>
|
|
|
|