Report data from different tables in similar way

[Achmed]

I'm need help! I have to create a report that summarizes records from two tables. For simplicity, lets say table1 stores information about various cars. Each record in table1 stores Make and Model. The report lists this data as follows (which works fine).

Volkswagen Jetta
Honda Accord

The problem is that I have another table, table2 which stores one Make and two Models in each record (ie Porsche; 911; Boxter)
I have to add this information from table2 to the existing report so that each record from table2 will be shown on two lines:

report should look like this:

Volkswagen Jetta
Honda Accord
Porsche 911
Porsche Boxter

How do I do this?
Thanks in advance.

 

[shannonp]

Presuming that table2 has Make ; Model#1 ; Model#2 I would first create 2 queries

table2A: Make; Model#1 As Model

table2B: Make; Model#2 As Model

Then just make a union query to combine table1, table2A and table2B.

Hope this helps