Combining items from child tables

[ColeChaW]

I have a table of people connected to a table of phone numbers. Each person can have multiple phone numbers in the phone table, but each number is connected to only one person. This is done by tagging each phone entry with the primary key of the person who owns it. I'm not sure the proper relationship term for this.

I would like to create a report containing personal phone numbers, however I'm having trouble getting name and the two or three numbers each person has on the same line. Is there a way to do this or should I reconfigure the people table to contain slots for each phone number?

tblPeople
PeopleID
NameFirst
NameLast

tblPhone
PhoneNumber
PhoneType
PeopleID

or... is this better?

PeopleID
NameFirst
NameLast
PhoneHome
PhonePager
PhoneCell
PhoneWork
PhoneOther

Thanks in advance, you guys are always helping me out with this funny VBA stuff.

 

[pbaldy]

I'd use your first sample (2 tables). There are various ways to present the data on one line. Here's one:

http://support.microsoft.com/kb/210163/en-us

 

[ColeChaW]

Paul, thank you so much. That is exactly what I need. Thanks for the help, I was lost searching for what I needed and not knowing the proper terms for it. =)