DataDoIt
|
| Posted: 02/04/2004, 10:44 AM |
|
CCS2, PHP4, MySQL4
This is actually an extenuation of the header/detail thread. I think this
might make more sense to word this way....
On a single CCS page, I have a Record view with Add/Update at the top
(header). I would like to have a Grid view without Add/Update at the bottom
(detail). When the record is displayed (or chosen from a previous search
grid), I would like the bottom detail to also display without having to
click a link in the header portion since the header portion only contains at
any time a single record.
Record header's Table1 has RecordID.
Grid detail is built on two tables, Table1 (one) and Table2 (to many),
linked as the data source, with a RecordID in both tables.
How do I get the detail to display the records I want based on RecordID in
header?
Thanks again.
-Mike R.
|
|
|
 |
DonB
|
| Posted: 02/04/2004, 2:16 PM |
|
Just be sure to set the datasources on each control so that is uses the same
selection criteria, then they will "track" (as long as the data in the
database tracks as well). On the bottom one, just delete the buttons you
don't want, or set the "allow" properties to "No" for insert.update/delete
as desired..
There still has to be "something" that designates the selection of records
to display (if you aren't clicking a link to get the value). This is
probably a query parameter (on the URL) or a session variable that you set
someplace (maybe the userid, set when they logged in). You have to include
this criteria into the datasource for each control - which causes it to
become part of a "WHERE x=y" clause in the SQL statement that the database
executes.
--
DonB
http://www.gotodon.com/ccbth
"DataDoIt" <mike@datadoit.com> wrote in message
news:bvreib$c3s$1@news.codecharge.com...
> CCS2, PHP4, MySQL4
>
> This is actually an extenuation of the header/detail thread. I think this
> might make more sense to word this way....
>
> On a single CCS page, I have a Record view with Add/Update at the top
> (header). I would like to have a Grid view without Add/Update at the
bottom
> (detail). When the record is displayed (or chosen from a previous search
> grid), I would like the bottom detail to also display without having to
> click a link in the header portion since the header portion only contains
at
> any time a single record.
>
> Record header's Table1 has RecordID.
>
> Grid detail is built on two tables, Table1 (one) and Table2 (to many),
> linked as the data source, with a RecordID in both tables.
>
> How do I get the detail to display the records I want based on RecordID in
> header?
>
> Thanks again.
>
> -Mike R.
>
>
|
|
|
|
DataDoIt
|
| Posted: 02/06/2004, 4:33 PM |
|
Okay, I'm getting close on this, as I've been able to see the header/detail
for a page without using a URL. However, on my page, the detail trigger
that I need isn't in the URL, so I guess I need to reference a session
variable.
Now, how to do that? :)
For the record header information at the top of the page, there is a unique
field that is displayed in a label that I could use. How do I take the
value of that label and put into a session variable? I think it may be to
Add an Event in the record grid's After Execute Select to Set Value for
Variable, give it a name, set it to session.
For the detail gridd information at the bottom of the page, I would set a
parameter to look for the newly set session variable above.
My big question is what is the best way to set a session variable based on
the value of a label on a page, then use that variable on the same page?
"DonB" <~ccbth~@gotodon.com> wrote in message
news:bvrr0f$eim$1@news.codecharge.com...
> Just be sure to set the datasources on each control so that is uses the
same
> selection criteria, then they will "track" (as long as the data in the
> database tracks as well). On the bottom one, just delete the buttons you
> don't want, or set the "allow" properties to "No" for insert.update/delete
> as desired..
>
> There still has to be "something" that designates the selection of records
> to display (if you aren't clicking a link to get the value). This is
> probably a query parameter (on the URL) or a session variable that you set
> someplace (maybe the userid, set when they logged in). You have to
include
> this criteria into the datasource for each control - which causes it to
> become part of a "WHERE x=y" clause in the SQL statement that the database
> executes.
> --
> DonB
>
> http://www.gotodon.com/ccbth
>
>
> "DataDoIt" <mike@datadoit.com> wrote in message
>news:bvreib$c3s$1@news.codecharge.com...
> > CCS2, PHP4, MySQL4
> >
> > This is actually an extenuation of the header/detail thread. I think th
is
> > might make more sense to word this way....
> >
> > On a single CCS page, I have a Record view with Add/Update at the top
> > (header). I would like to have a Grid view without Add/Update at the
> bottom
> > (detail). When the record is displayed (or chosen from a previous
search
> > grid), I would like the bottom detail to also display without having to
> > click a link in the header portion since the header portion only
contains
> at
> > any time a single record.
> >
> > Record header's Table1 has RecordID.
> >
> > Grid detail is built on two tables, Table1 (one) and Table2 (to many),
> > linked as the data source, with a RecordID in both tables.
> >
> > How do I get the detail to display the records I want based on RecordID
in
> > header?
> >
> > Thanks again.
> >
> > -Mike R.
|
|
|
|
|
