i have looked at many posts in this forum and others about this but haven't been able to find anything yet that i have been able to successfully apply to my situation.
i have two forms, main form (F_AbMRB) is based on a table (tbl_AbMRB) and subform (T_ProductsCase_subform1) is based on a table (tbl_ProductsCase). Tables/forms are linked on field AbMRBID.
presently the field AbMRBID can have multiple product codes associated, which is why I created the subform. Each product can be listed under multiple case id's as well. (If i listed these by product code, i'd have lots of duplicated data.) The subform works properly; only showing records related to the main form linked by parent (AbMRBID) field.
i'd like to be able to search on ProductsID field (in tbl_ProductsCase/T_ProductsCase_subform1) through all the subform data and "go to" the related parent record(s).
is it possible?
i have two forms, main form (F_AbMRB) is based on a table (tbl_AbMRB) and subform (T_ProductsCase_subform1) is based on a table (tbl_ProductsCase). Tables/forms are linked on field AbMRBID.
presently the field AbMRBID can have multiple product codes associated, which is why I created the subform. Each product can be listed under multiple case id's as well. (If i listed these by product code, i'd have lots of duplicated data.) The subform works properly; only showing records related to the main form linked by parent (AbMRBID) field.
i'd like to be able to search on ProductsID field (in tbl_ProductsCase/T_ProductsCase_subform1) through all the subform data and "go to" the related parent record(s).
is it possible?
