Filtered Drop Down
Posted: Fri Mar 21, 2008 6:03 am
Hi all,
I will try to explain this the best I can.
OK,
1. I have a drop down menu which is getting its values from a table in my DB. (Business) Working great!
2. I have a text field on the same page with a plus (add) button. (Contact) Easy
3. When I click this plus (add) button, I want to open a new page which will list contacts however I want to filter the contacts to only show the available people for the select business from the drop down.
4. Then inside this popup window have a select button which will close the window and insert the selected contacts name into the contact text field.
So for example:
Business One - Person One, Person Two;
Business Two - Person One, Person Three, Person Four;
If Business One is selected in the drop down then the contact list will only show Person One and Person Two.
Step 3 and 4 is what I am struggling on. Any ideas?
I will try to explain this the best I can.
OK,
1. I have a drop down menu which is getting its values from a table in my DB. (Business) Working great!
2. I have a text field on the same page with a plus (add) button. (Contact) Easy
3. When I click this plus (add) button, I want to open a new page which will list contacts however I want to filter the contacts to only show the available people for the select business from the drop down.
4. Then inside this popup window have a select button which will close the window and insert the selected contacts name into the contact text field.
So for example:
Business One - Person One, Person Two;
Business Two - Person One, Person Three, Person Four;
If Business One is selected in the drop down then the contact list will only show Person One and Person Two.
Step 3 and 4 is what I am struggling on. Any ideas?