Can't see the difference between these 2 requirements when they apply to the same control. If you want more than one set of attributes (fields) for a given entity then make sure those fields are included in the combo row source sql or query and that you have enough combo columns visible to show them.
I'm sorry that my question is not unclear. The details are listed below
I have two tables;
tblPQual has record(s) of tutors' post qualifications
tblPQual (ID, AutoNumber; TRef, unique key of tblTutor; S_Code, Code of the Post Qualification and is foreigner key of tblSpecialty)
e.g.
TRef, S_Code
...
671, 3
671, 6
...
tblSpecialty has all post qualifications I maintain
tblSpecialty (ID, AutoNumber; S_Code, Unique specialty code; S_Abbr, Abbreciation of Specialty; S_Desc, Specialty Description; S_Type, 1..4)
e.g.
S_Code, S_Abbr, S_Desc, S_Type
...
3, DABFP, Diplomate of the American Board of Family Practice, 1
6, FRACGP, Fellow of Royal Australian College of General Practitioners, 1
...
I populate a combo box with
1) recordset of tblSpecialty and then
2) need to highlight/mark the item(s) in the same combo box which a tutor has in the table of tblPQual.
I manage to do item 1) above but no idea of how to work out item 2).