[AccessD] Matching Names & Qualifications

Note: Changed Engineer to Evaluator.


Master & Child of the subform linked on EvaluatorID

Subform:
SELECT tbl_EvalQual.EvalQualID, tbl_EvalQual.QualID,
tbl_EvalQual.EvaluatorID, tbl_EvalQual.DateQual
FROM tbl_Qual INNER JOIN tbl_EvalQual ON tbl_Qual.QualID =
tbl_EvalQual.QualID
ORDER BY tbl_Qual.Qual;

Main Form:
tbl_Evaluator

Combo for the Evaluator on Main form:
SELECT DISTINCTROW tbl_Evaluator.EvaluatorID, [FirstName] & " " & [Lastname]
AS Evaluator
FROM tbl_Evaluator
ORDER BY [FirstName] & " " & [Lastname];

I also did the same thing as above on another form to select the
Qualifications and list the Evaluators that match the selected
qualification.


-----Original Message-----
From: Andy Lacey [mailto:andy at minstersystems.co.uk]
Sent: Saturday, March 15, 2003 10:35 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Matching Names & Qualifications


Virginia
How have you done the subform? Are you using Master and Child linking?
If so is the main form bound to the Engineers table? Or is the subform
bound to a query which has a criteria that looks at the combo on the
main form? If you can describe how you've done it I/we can help more
easily. 

Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-admin at databaseadvisors.com 
> [mailto:accessd-admin at databaseadvisors.com] On Behalf Of 
> Hollis,Virginia
> Sent: 15 March 2003 15:01
> To: 'accessd at databaseadvisors.com'
> Subject: RE: [AccessD] Matching Names & Qualifications
> 
> 
> Never mind, I got the form working.
> 
> Just one last question.
> 
> I have an unbound combo box that lists the Engineers, then 
> afterUpdate it shows the qualifications for the selected Engineer.
> 
> Question: When the form opens the Engineer combobox is blank 
> but the qualifications subform lists the qualifications. 
> Should the form & subform open blank? How can I have the form 
> open to a blank record? Or at least the first engineer & 
> their qualifications.
> 
> Virginia
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
> 

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com