Fetting Data from Relational database? help!

[DenItech]

I have a question that seems kinda easy. I want to get data from 2 tables where there is a 1 to many relationship.
The first table consist of the person name, The second table has 4 of his phone number in it. How can I combine
The two table so that it will have this (name ,1st phone number, 2nd number, 3rd number, 4th number) Plz help!!!

Thank you

 

[thojohp]

This is my first post where I am answering a question... please bear with me.

If I am understanding correctly, you will need to create a query and choose both of your tables when creating the query. You can do this when the "Show Tables" menu is up (or right click to choose it from the menu). Then, link the two tables by the common key (whatever you are using). If you need to edit the join properties, choose View>Join Properties.

I hope this helps,

John