1. I have table structure and record like this:
tbDept(a)
DeptID : 1,2,3,4,5
tbPIC(b)
PICID: 1,2,3,4,5,6,7,8,9………..
DeptID : 1,1,1,2,3,4,5,1,1……….
PICName
A ¦ Alex ¦ blabla ¦
A ¦ Betrand ¦ zzzzzzzz ¦
My question is, how if I don’t want to display Dept Name for Betrand b’coz in the previous record (Alex) has same department with bertrand?
2.
Request Date : list/menu
Request By: list/menu
Status: list/menu
Product: list/menu
Department: jump menu
I have form like above. If user select Department others input will be back to normal for example Request will be back to > All Request although user have selected it. How’s the solution if input that user have selected remain the same after select department?