Fred B
|
| Posted: 11/13/2002, 2:49 PM |
|
I'm a long time asp programmer who always programmed directly with an html
editor, giving me powerful but visually ugly data applications. I'm
switching my coding preference to PHP. I chanced upon cc and ccs, and I'm
knocked out by their potential, but stymied by the details. I'm evaluating
both, but want to go with ccs because it seems more powerful, but less
intuitive. I have what should be a simple problem, but can't figure it out,
and don't see anything similar in the examples.
Just a master-detail list. I have a master table of (company) accounts and a
detail table of contacts. In the last column of tblAccount grid, I want to
add a column with a button or label called Contacts. Clinking the link or
button will bring up the tblContacts grid, just showing the contacts for
that account. The key in tblAccounts is called AccountID, the foreign key in
tblContacts is called ContAccountID.
How do I define the link I'm adding?
thanks for your help.
Fred
|
|
|
 |
Fred B
|
| Posted: 11/13/2002, 4:19 PM |
|
Also, I was able to do this with cc, even creating three levels of detail.
Why is ccs so much harder to follow?
Fred
"Fred B" <fredb@nospam-groupworksdev.com> wrote in message
news:aqukt1$vtq$1@news.codecharge.com...
> I'm a long time asp programmer who always programmed directly with an html
> editor, giving me powerful but visually ugly data applications. I'm
> switching my coding preference to PHP. I chanced upon cc and ccs, and I'm
> knocked out by their potential, but stymied by the details. I'm evaluating
> both, but want to go with ccs because it seems more powerful, but less
> intuitive. I have what should be a simple problem, but can't figure it
out,
> and don't see anything similar in the examples.
>
> Just a master-detail list. I have a master table of (company) accounts and
a
> detail table of contacts. In the last column of tblAccount grid, I want
to
> add a column with a button or label called Contacts. Clinking the link or
> button will bring up the tblContacts grid, just showing the contacts for
> that account. The key in tblAccounts is called AccountID, the foreign key
in
> tblContacts is called ContAccountID.
>
> How do I define the link I'm adding?
>
> thanks for your help.
>
> Fred
>
>
|
|
|
|
Fred B
|
| Posted: 11/14/2002, 4:42 AM |
|
Never mind, I got it.
"Fred B" <fredb@nospam-groupworksdev.com> wrote in message
news:aqukt1$vtq$1@news.codecharge.com...
> I'm a long time asp programmer who always programmed directly with an html
> editor, giving me powerful but visually ugly data applications. I'm
> switching my coding preference to PHP. I chanced upon cc and ccs, and I'm
> knocked out by their potential, but stymied by the details. I'm evaluating
> both, but want to go with ccs because it seems more powerful, but less
> intuitive. I have what should be a simple problem, but can't figure it
out,
> and don't see anything similar in the examples.
>
> Just a master-detail list. I have a master table of (company) accounts and
a
> detail table of contacts. In the last column of tblAccount grid, I want
to
> add a column with a button or label called Contacts. Clinking the link or
> button will bring up the tblContacts grid, just showing the contacts for
> that account. The key in tblAccounts is called AccountID, the foreign key
in
> tblContacts is called ContAccountID.
>
> How do I define the link I'm adding?
>
> thanks for your help.
>
> Fred
>
>
|
|
|
|
JCF
|
| Posted: 11/14/2002, 7:40 AM |
|
Hi Fred B
What was your answer - I also am interested in what you did.
Thanks
"Fred B" <fredb@nospam-groupworksdev.com> wrote in message
news:ar05nb$l5r$1@news.codecharge.com...
> Never mind, I got it.
>
> "Fred B" <fredb@nospam-groupworksdev.com> wrote in message
>news:aqukt1$vtq$1@news.codecharge.com...
> > I'm a long time asp programmer who always programmed directly with an
html
> > editor, giving me powerful but visually ugly data applications. I'm
> > switching my coding preference to PHP. I chanced upon cc and ccs, and
I'm
> > knocked out by their potential, but stymied by the details. I'm
evaluating
> > both, but want to go with ccs because it seems more powerful, but less
> > intuitive. I have what should be a simple problem, but can't figure it
> out,
> > and don't see anything similar in the examples.
> >
> > Just a master-detail list. I have a master table of (company) accounts
and
> a
> > detail table of contacts. In the last column of tblAccount grid, I want
> to
> > add a column with a button or label called Contacts. Clinking the link
or
> > button will bring up the tblContacts grid, just showing the contacts for
> > that account. The key in tblAccounts is called AccountID, the foreign
key
> in
> > tblContacts is called ContAccountID.
> >
> > How do I define the link I'm adding?
> >
> > thanks for your help.
> >
> > Fred
> >
> >
>
>
|
|
|
|
Fred B
|
| Posted: 11/14/2002, 7:46 AM |
|
In the calling form, set up a link with the source/parameter property set to
the page you are calling.
On the page you are calling, define a grid, and in the grid's data source
you can add the field relationships to the parameters using the "where" box.
Fred.
"JCF" <jcf@mail.org> wrote in message
news:ar0g5h$84j$1@news.codecharge.com...
> Hi Fred B
>
> What was your answer - I also am interested in what you did.
>
> Thanks
>
> "Fred B" <fredb@nospam-groupworksdev.com> wrote in message
>news:ar05nb$l5r$1@news.codecharge.com...
> > Never mind, I got it.
> >
> > "Fred B" <fredb@nospam-groupworksdev.com> wrote in message
> >news:aqukt1$vtq$1@news.codecharge.com...
> > > I'm a long time asp programmer who always programmed directly with an
> html
> > > editor, giving me powerful but visually ugly data applications. I'm
> > > switching my coding preference to PHP. I chanced upon cc and ccs, and
> I'm
> > > knocked out by their potential, but stymied by the details. I'm
> evaluating
> > > both, but want to go with ccs because it seems more powerful, but less
> > > intuitive. I have what should be a simple problem, but can't figure
it
> > out,
> > > and don't see anything similar in the examples.
> > >
> > > Just a master-detail list. I have a master table of (company) accounts
> and
> > a
> > > detail table of contacts. In the last column of tblAccount grid, I
want
> > to
> > > add a column with a button or label called Contacts. Clinking the link
> or
> > > button will bring up the tblContacts grid, just showing the contacts
for
> > > that account. The key in tblAccounts is called AccountID, the foreign
> key
> > in
> > > tblContacts is called ContAccountID.
> > >
> > > How do I define the link I'm adding?
> > >
> > > thanks for your help.
> > >
> > > Fred
> > >
> > >
> >
> >
>
>
|
|
|
|
|
