Query criteria for field containing a character from another field in the same query

[Mattbro]

Hello everyone. I have 2 tables-TblStaff and TblTraining.



TblStaff has a field 'Category' which lists the training profile code for each staff member ('a' to 'g' depending on post).

TblTraining lists each training element and has a field 'Category1' in which the relevent training profile codes are listed e.g. Element ABC1 may be relevant to staff groups 'a', 'e', and 'f', thus the Category1 Field for Element ABC1 would be 'aef'.

I am trying to write a query that picks the Staff ID from a combo box and lists the Staff ID and Category from TblStaff with all relevent Training Elements for that member of staff from TblTraining. I have started with the following code

SELECT TblStaff.StaffID, TblStaff.Category, TblTraining.Element, TblTraining.SOP, TblTraining.Category1
FROM TblStaff, TblTraining
WHERE (((TblStaff.StaffID)=[Forms]![FrmTraining]![Combo1]) AND (((TblTraining.Category1) Like [TblStaff.Category]));

'Like' only returns the value where TblTraining.Category is identical to TblStaff.category. Cant get '*'s and '"'s into the criteria field and I don't know where to start with the SQL for "any field in 'TblTraining.Category1' that contains the same letter as TblStaff.Category". If anyone could point me in the right direction, I would be grateful.
Many thanks,
Mattbro

[Mattbro]

Bah!

SELECT TblStaff.StaffID, TblStaff.Category, TblTraining.Code, TblTraining.Activity, TblTraining.SOP, TblTraining.Category1
FROM TblStaff, TblTraining
WHERE (((TblStaff.StaffID)=[Forms]![FrmPreC]![Combo1]) AND ((TblTraining.Category1) Like "*[TblStaff.Category]*"));

[Mattbro]

Hmm-doesn't work. Doesn't filter out the categorys that don't have the relevant letter in the TblStaff.Category. Any ideas?

[orange]

I'm not following your description of the issue. A lot of times with situations involving

-employees, their acquired training, the positions they occupy and the training requirements of the position-
it is a table/data structure based issue.

This diagram may help, but as I said, the post isn't clear (to me at least).

Good luck.