Hello,
I would like to make a CodeJock Report which reads data from a parent table and from a child table. The find process would be (more or less):

Code:
 
Find ge parent by index.1
While (Finderr=false)
            Move false to bHasChildren
            Clear child
            Move parent.id to child.id
            Find ge child by index.1
            While (finderr=false and child.id=parent.id)
                        // Here I show data from parent and child table
                        // The “Show” represents each columns
                        Move True to bHasChildren
                        Show parent.id
                        Show parent.name
                        Show child.field_x         
                        Showln “”          
                        Find gt child by index.1  
            Loop
            If (hasChildren=false) begin
                        // Here I show data onlu from parent table (he doesn’t have childs)
                        Show parent.id
                        Show parent.name
                        Show “”
                        Showln “”
            end
            Find gt parent by index.1
Loop
I think that isn’t possible with a constrain, so I can’t use the “PeDb_Type” property to “eRC_db_Table” because (I think...) it uses constrains

Is there any way to do that?

Thank you.

Victor M. Diego
A.T. MEDTRA, S.L.
Santander-Spain