How to Report using two tables and unequal rows

[KHerm]

This may be a duplicate, so I apologize.

I am writing an Access report with two tables. One account has two rows in the first table and three rows in the second table. I want the report to show only the two rows from the first table and the three rows from the second table where the account numbers are equal. The best I've done so far is each row from the first table and the three rows from the second table twice.

Ken
khermonat@comspec-intnl.com

 

[MichaelRed]

Sounds like a many-to-many relationship. Classic soloution is an intermediate table where each of hte current tables has a many-to-one relationship to the new table.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[KHerm]

Thank you for responding. I always appreciate those who take time to help. I just learned I need to be clearer in my questions. I needed help on how to pull those many-to-one tables into an Access form. Got the information from a friend, so I'm on my way!

Thanks again.