JimmyCrackedCorn
Posts: 583
|
| Posted: 05/05/2007, 12:26 AM |
|
I'm trying to create a non-editable, master detail page and cannot seem to figure out how to do this. I tried looking at the example master-detail page but it did not help.
- I have a table named households
- I have a table named members
- each record in households will have several records in members linked to it
I want to have a separate page that lists households and when someone clicks on any household the master-detail page comes up (non-editable) as shown below,
--------
household info
--------
member1 info
--------
member2 info
--------
memberX info
--------
any ideas would be greatly appreciated!
_________________
Walter Kempees...you are dearly missed. |
 |
 |
JimmyCrackedCorn
Posts: 583
|
| Posted: 05/07/2007, 2:42 AM |
|
I am really exhausted on this seemingly simple problem!!! spent all weekend night and day trying to solve it. maybe CCS just won't do this.
I thought I'd try again here but this time use pictures of what I have and what I want! Any help would be greatly appreciated!
The first link shows a picture of what I set up with CCS using a greatly simplified example and database to try and reduce this problem to its smallest form!
http://www.winpath.com/ccs/1.gif
.
_________________
Walter Kempees...you are dearly missed. |
|
|
|
JimmyCrackedCorn
Posts: 583
|
| Posted: 05/07/2007, 2:44 AM |
|
the next picture shows what happens when I enter 3 for the search ID and click the Search button.
only one of the grids is updated but I wanted them both to update!
http://www.winpath.com/ccs/2.gif
.
_________________
Walter Kempees...you are dearly missed. |
|
|
|
JimmyCrackedCorn
Posts: 583
|
| Posted: 05/07/2007, 2:44 AM |
|
finally, this picture shows what I want to happen. I did this "screenshot" in Photoshop because I couldn't get CCS to display this result!
http://www.winpath.com/ccs/3.gif
.
_________________
Walter Kempees...you are dearly missed. |
|
|
|
Wkempees
|
| Posted: 05/07/2007, 7:34 AM |
|
In the third grid:
Through the DataSource Visual Query Builder
Set the table to be the third table familymembers
Change the Where to:
fk_households = s_id_households type URL
Now I am guessing the s_id_households, because your pictures do not show
the URL, but you can find it yourself as it is basically the same where
as in Grid1
Come on, you can do it!
Walter
|
|
|
|
JimmyCrackedCorn
Posts: 583
|
| Posted: 05/07/2007, 2:18 PM |
|
thanks Walter. Actually tech support got back to me and outlined the steps I was missing. now it works. Yay!
_________________
Walter Kempees...you are dearly missed. |
|
|
|
