Hi
Have a searchselectadvanced field that has a createscript in the Case Details screen to prepare the SearchSQL statement to filter the allowable values.
(EquipRec = Values("case_equipment");
FC = Values("case_faultcode");
SearchSQL="ProductGroupID…