Hi
I have TblSpareparts with fields SPID, Desc., EquID (The Equipment to this spare part is assigned), etc
I have created two tables to record the history of changing spare parts as "TblSPChangeHead" have fields "ChangeID", "Dated" and EquID" etc and respresnts "FrmSPChange" whereas TblSpChangeDetails" SChangeID, ChangeID (FK), SPID(FK), etc and represents subform "SfrmSPChange"
Requirement:
If select a equipment from combo box (CboEqu) then at subform the list of assigned spare parts should be only shown in combo box "CboSpare" than whole list.
Regards