Hi all,

This is the first time I've tried to create more than the simplest report and I'm somewhat confused as to how to handle 1-m table relationships in a report.

I have 2 tables (AddressBook, and Addresses).

I want to make a report that prints 1 entry for each record in the AddressBook table and it's related Address records (there are 3 addresses per addressbook).

For example each AddressBook record would print out like the following:

Company Name 1
Address1
Address2
Address3

Company Name 2
Address1
Address2
Address3

I had thought to just create a view with a join on the 2 tables and dump it in the reports DE. Is that the best way?

Or should I create a view for each table? If so how do you relate them?

Thanks for any help.