Ok this is a slightly complicated one, and I'd accept any method at this point(not just the one I'm trying)

STUDENT TABLE:
studID
reg-code
name...etc

PARENT TABLE:
ParID
name...etc

STUDPARENT TABLE:
studparID
studID
parID

CONTACTS TABLE:
ContactID
TelephoneNum
Type

PARCON TABLE:
parconID
parID
ContactID

PARENT SEARCH QUERY:
Full(this is a concatonated string of the student name)
NameFirst(Parent FIrst NAme)
NameLast(Parent Last Name)
TelephoneNum
Type

The purpose of the query is to research the Parent associated with any student, and their phone number (s) and type. What I want to do exactly is to have the user select the student's full name from a list (as in Full field in the query) and have the Parents and their phone numbers appear, but exclusive to that student. And then when done, the user could select another student from the list and have that info appear.

Any suggestions at all.

Create a query based on tblPARCON, tblContact and tblParent. Be sure and include ParID. Create a form based on this query and save it. Create a query based on STUDPARENT table. Make ParID the first column and add student info. Save this query. Create a form and add a combo box based on the last query you made. Add the form you made earlier as a subform. Set the MasterLink of the subform to the name of your combo box and the ChildLind to ParID (You will have to do this manually). Now selecting a student in the combo should show their parents inform, etc..

This has been done in my head so check it as you go...

hth,
Jack

Ok gr8, it works. tyvm. But how do I hide the ParentID from the drop down box? (the number appears there after the name and may make no sense to the user...)

If the combo box has 2 columns then set the Column Count property to: 2. Set the Column Widths property to: 0";1".
Be sure the Bound Column is: 1. The Bound Column is under the Data tab and the other properties under the Format tab...

hth,
Jack

yes it helped...a lot. Now I'm going to do another very similar form and I bet it'll be done in no time. Thanks very much for your help Jack, and the very fast response.

You are most welcome and continued success with the project!

Jack