Jan 22 2007, 06:51 PM
Ok this is a slightly complicated one, and I'd accept any method at this point(not just the one I'm trying)
PARENT SEARCH QUERY:
Full(this is a concatonated string of the student name)
NameFirst(Parent FIrst NAme)
NameLast(Parent Last Name)
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.
Jan 22 2007, 07:26 PM
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...
Jan 23 2007, 07:02 PM
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...)
Jan 23 2007, 07:06 PM
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...
Jan 23 2007, 07:13 PM
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.
Jan 23 2007, 07:18 PM
You are most welcome and continued success with the project!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here