Hi
I have created a two table Process and category where process contains process steps and category contains different category depending on process I want to create a combo box such that when I select process , categories related to process has to be drop down.
I have 2 tables ProcessT(PID,Process name) and categoryT(CID,Pid,category name) after using below process its showing blank in category field in combo box
After executing the
SELECT TblCategory.Category, TblCategory.ProcessID
FROM TblCategory
WHERE (((TblCategory.ProcessID)=[Forms]![FormTest]![cmbProcess]));
query it is showing blank bcz of this my combo box is not working as desired
plz help!!