This should be easy, I do it all the time in MS Access. I want to have an address book report which shows names, addresses, phone numbers, emails, etc.
The names and addresses are in the main contacts table, while the phones and emails are in their own tables, linked by relationships to the contacts table. Therefore, I will need a portal for each.
It should look something like:
Sam Adams Home: 888-888-8888
1234 Main St. Cell: 888-555-5555
Anytown, CA 99999 Email1: Sam@me.com
Joe Anderson Home: 777-888-8999
2345 Main St. Work: 333-333-3333
MyTown, CA 33333 Email1: Joe@me.com
Later I will attempt to make it multi-column so I get 2 columns on each page. for now, I need to figure out how to group this and do the portals so it comes out looking like the above example. It should group on the first letter of the last name.
Any ideas on how to do this? Thanks in advance.