How do I split up one column with multiple rows related to one person into a query

[pacific0786]

I have an Access Database and I want to split up one column into multiple columns. The one column has multiple rows that relate to one person, so for instance I have the following: I am taking information from both tables and I want to create a query but I need to separate out the mother, father, and guardian with the names attached

So from the Child table :

Joe Smith Address Phone


The query that I created is from two tables, the child table and the family table: ( I used the dashes just for it to be easier to read)


------Child Table/PrimaryKey --------Family Table---------------------

First Name--- Last Name--- First Name--- Last Name--- Relationship
Joe ----------------Smith ----------Jane --------Doe-------------Mother
Joe ----------------Smith ----------John---------Smith---------- Father

So in this scenario I need to get the name of the second parent in another column....meaning have all the parents appear on the same line for this child, and each child there after....I just can't figure this out...I am hoping someone can help.

So I need it to look like this:

------Child Table/PrimaryKey --------Family Table---------------------



First Name------ Last Name------ First Name------ Last Name------ Relationship------ 2First Name------2Last Name------2Relationship
Joe----------------Smith------------ Jane-------------- Doe------------- Mother-----------John---------------- Smith------------ Father

[rzw0wr]

Can you show a picture of your tables.

Dale