Hello guys , i have urgent inquiry , i have a table (attached )
I wanna to create form with combo box , when i select company code , it automatically filter the cells contain the same company code , for example , if i select CCF from my drop list , and go to query , i found the columns with CCF code only , cuz when i try to do that , all headers appeared, which contain the company code also the empty cells which is wrong , so any help guys ?
I wanna to create form with combo box , when i select company code , it automatically filter the cells contain the same company code , for example , if i select CCF from my drop list , and go to query , i found the columns with CCF code only , cuz when i try to do that , all headers appeared, which contain the company code also the empty cells which is wrong , so any help guys ?