>I have a unique ID table, we'll call it IDtable.IDfield.
>I also have 3 other tables: table1, table2, and table3.
>
>Each of these tables have the fields: field1, field2, field3; in which field1 is linked to IDtable.IDfield, and field 3 can be any of the values 1, 2, or 3.
>
>I want each row of my report to be a successive record these tables with these conditions:
>
>(record 1)
>IDtable.IDfield--table1.field2(if table1.field3 is value '1')--table2.field2(if table2.field3 is value '2')--table3.field2(if table3.field3 is value '3')
>
>(new line for record 2)
>IDtable.IDfield--table1.field2(if table1.field3 is value '1')--table2.field2(if table2.field3 is value '2')--table3.field2(if table3.field3 is value '3')
>
>(new line for record 3)
>IDtable.IDfield--table1.field2(if table1.field3 is value '1')--table2.field2(if table2.field3 is value '2')--table3.field2(if table3.field3 is value '3')
>
>any ideas?
What if all satisfy the condition for a particular record ? I guess you control it by some means.
You have numerous options to create it. ie:
-Create the report with 3 of the fields overlapped and set their "print when"
-Create an SQL cursor first and report from that cursor (my preference)
Cetin