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..........
And I would like to display table for client side like this:
==========================
Dept ¦ Staf Name ¦ Description ¦
==========================
A ¦ Alex ¦ blabla ¦
A ¦ Betrand ¦ zzzzzzzz ¦
B ¦ Thomas ¦ ssstt ¦
==========================
My question is, how if I don't want to display Dept for Staf Name is Betrand [s]b'coz[/s] because 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
[url=http://forums.devnetwork.net/viewtopic.php?t=30037]Forum Rules[/url] Section 1.1 wrote:11. Please use proper, complete spelling when posting in the forums. AOL Speak, leet speak and other abbreviated wording can confuse those that are trying to help you (or those that you are trying to help). Please keep in mind that there are many people from many countries that use our forums to read, post and learn. They do not always speak English as well as some of us, nor do they know these aberrant abbreviations. Therefore, use as few abbreviations as possible, especially when using such simple words.
Some examples of what not to do are ne1, any1 (anyone); u (you); ur (your or you're); 2 (to too); prolly (probably); afaik (as far as I know); etc.