I have a query that had a thing some information and the person responcible for it. kind of like this
12341201 Sam
14525166 Ian
15648463 Ian
14584853 Bob
56646466 Sam
89414672 Bob
54668469 Bob
Well what I need to be able to do is make a drop down box with each name in it and when I select that name all of the things that they are responcible for will show up.
There is also some that have no one being responcible for and in that case I would just like to be able to see the ones with no one responcible for them.
Any help would be appreciated.
12341201 Sam
14525166 Ian
15648463 Ian
14584853 Bob
56646466 Sam
89414672 Bob
54668469 Bob
Well what I need to be able to do is make a drop down box with each name in it and when I select that name all of the things that they are responcible for will show up.
There is also some that have no one being responcible for and in that case I would just like to be able to see the ones with no one responcible for them.
Any help would be appreciated.