jump menu

[Rikyoni]

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..........

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 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

[dreamcatcher]

Hi Rikyoni,

I`m a little unclear what you are asking I`m afraid and I`m guessing other people are too as you have had no replies. Can you give us some more information please and we might be able to help.

dc

[mcibor]

I read it twice, and to say the truth I don't know two things:

1. I don't know your table structure
tbDept(a)
DeptID : 1,2,3,4,5 - does this table have 5 columns? What for?
What does it store?

2.
tbPIC(b)
PICID: 1,2,3,4,5,6,7,8,9...........
DeptID : 1,1,1,2,3,4,5,1,1..........
What is PIC (picture?) Why id? is DeptID connected with tbDept(a)?

3.
Where is this data stored? I am sure I haven't seen it anywhere before...
==========================
Dept ¦ Staf Name ¦ Description ¦
==========================
A ¦ Alex ¦ blabla ¦
A ¦ Betrand ¦ zzzzzzzz ¦
B ¦ Thomas ¦ ssstt ¦
==========================

4.
And the most important - what is your question?
My question is, how if I don't want... - "How" what? How is Betrand?

please be more clear
And welcome to Webmasterworld!

Michal