Marc
|
| Posted: 07/05/2002, 8:25 AM |
|
The old CC had an easy to generate master-detail wizard, I can't seem to find the same wizard in the all new CC Studio, am I overlooking something? Any guidance?
Thank you. Marc.
|
|
|
 |
Chris K.
|
| Posted: 07/05/2002, 1:57 PM |
|
Isn't Grid and Record Builder something similar?
|
|
|
|
Nicole
|
| Posted: 07/08/2002, 12:37 AM |
|
Marc,
CCS doesn't include Master-Detail wizard. You should run Grid&Record wizard twice: one for master table and the second one for detail.
|
|
|
|
Peter
|
| Posted: 07/08/2002, 1:33 PM |
|
I tried running Grid and Record Builder twice for my master-detail records. But it doesn't seem to do all the parameter passing like the old CC wizard. Am I missing something? Does anyone know if this feature will be added to CCS?
|
|
|
|
Nicole
|
| Posted: 07/09/2002, 7:36 AM |
|
Marc,
CCS form builders won’t generate parameters passed between master/detail forms. You can create Grid&Record forms for the master table and Grid&Record forms for detail table. To link Grid forms set one of the field types on the master grid form to Link, go to its properties and set up:
Href Type: Page
Source/Parameters: click on dots icon to open Href Source dialog, select destination page (the page where detail grid form is located) and add Link Parameter. Click on plus icon and define following settings for the output parameter
Source Type: DataField
Parameter Source: select primary key field (that is foreign key for the detail table)
Parameter Name: field name is set be default
For the detail grid form you should add master table primary key in table parameters. Open Data Source dialog for the detail grid and click plus icon under Where section. Set up table parameter like:
Condition Type: Parameter
Field
Name: select foreign key
Type: Integer (as usual)
Condition: equals(=)
Parameter Source
Name: the same as specified in Parameter Name for the Link field
Type: URL
|
|
|
|
Bert Stevens
|
| Posted: 07/13/2002, 3:30 AM |
|
Isn't possible to create a page with a listing like:
[cat. name]
items from items table with cat==catname
items from items table with cat==catname
items from items table with cat==catname
[cat. 2 name]
items from items table with cat==cat2name
without much coding?
|
|
|
|
Meska
|
| Posted: 08/29/2002, 4:24 AM |
|
For Bert's question..
I was able to do something like this in php with a little trick:
table1: general article details
table2: measures and codes
[art 1]
field1,field2,field3
[table2]
row1
row2
row3
[art 2]
field1,field2,field3
[table2]
row1
row2
row3
------------
Creating a different page for [table2]
and putting something like this on one label of the grid on main page:
function products_Label1_BeforeShow() {
global $products;
$filename= "http://www.xxxx.com/codes.php?pr_id=".$products->Label1->GetValue();
$fd = fopen($filename, "r");
while (!feof ($fd)) {
$buffer = fgets($fd, 4096);
$contents.=$buffer;
}
fclose ($fd);
$products->Label1->SetValue($contents);
}
|
|
|
|
