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?