Icetips Products: Icetips SQL: Parent-Child multicomponent key 2002-09-18 -- Andy Stapleton Newsgroups: softvelocity.products.c55ee > C55ee - CCS templates > DB2 db on AS400, access through ODBC > I have a file with this structure : > > K1 - K2 - K3 - Loc - Quantity1 - Quantity2 - etc... > > The key is K1 - K2 - K3 - Loc > > When LOC = 0 : the quantities are the total of the records where LOC <> 0 > Om the browse, I have a parent file with only the records where LOC = 0 > > On the second browse, the child, I want to show the records where LOC <> 0 > > Obviously when a record is selected in the parent (total) I want to show the > detail records in the child browse. > I have used an alias to open the file twice > > in the CCS templates, I can do child synchronisation, but only on 1 ID > field. In my case there are 3 fields : K1,K2 & K3. > > Any idea how this can be done ? I need a fast access as the file contains +- > 100000 records. Set the first connection in the Child Syncronization... Go to the Source and search for that connection, you will find that it is a string putting the 2 fields together, cut and paste it into the embed point afterwards and add your other 2 fields.. -- Andy < Printed May 12, 2024, 3:23 am This article has been viewed/printed 35103 times. Google search has resulted in 26 hits on this article since January 25, 2004. |