Richard, Scott, et al,
I'm trying to create a equipment tracking system, similar to the order tracking system Richard creates in AccessExpert8 and AccessExpert22. But instead of sorting by order, as in Richard's aforementioned courses, I want to create a data entry form where I can sort by employee--the employee who has the equipment.  This obviously would be a one-to-many relationship, where each employee will have several types of unique equipment.
I have created an ITEquipmentF, where each person has several lines of equipment, with subform  ITEquipmentDetailF inside. But I'm having trouble getting a ComboBox sorting equipment by employee. I want to be able to select an employee and show all their equipment in my form, and possibly add new or archive old equipment turned back in.  
How can I do this?    
Thoughts?
--Kent J.