Help with contact info db?
Dear Collective Wisdom,
I'm dipping my toes back into FM after being away for awhile. I just upgraded to FM Pro 12. I'm playing around with a contact info db that I'd like to use for storing people's adresses, tel#'s, email, etc. I want to have a record for each individual person, but also have more than one record linked to one physical address, so that I could generate a mailing label that would list several people who lived at the same location. So clearly it's a one-to-many (or many-to-one?) situation. But I'm getting bogged down here when I try to make a pivot table, and am not sure what the best way to do this is.
As a sign of something being not right, when I created a report to show that kind of listing, I got the addresses to come out right, "sliding" to close up gaps, but names are not showing up.
(I was going to attach my files (they are small), but it's not clear to me how you do that in this forum.)