I have a Client Page which holds clients data that does not get changed. EX: Name Address ect...

I also have a Clients History Page
I wanted it to be able to list in 1 drop down box the following:
ID
Caller_Last_Name
Caller_First_Name

When this is picked from the Clients page then it would list the clients history. This is severly needed so that the database will function accordingly. In addition to this I have Chapter and Volunteer, when the Chapter is picked, I wanted the list of Volunteers to be filtered out. Please let me know the best way to get this done. I have tried listing multiple listing in 1 combo box with now success, the filtering has not been done yet

please advise asap. I have to get this done by monday

I think you will need to execute an sql join between the tables.
Maybe you can use some code from here.

You will need to add this to the script you are writing that processes the selected option.

The correlation can only be made if at least one column in the two tables contain related data.

Here is an example, the columns that contain related data are emp_id of employee_data and e_id of employee_per.

Here you conduct a table join and extract the names (from employee_data) and spouse names (from employee_per) of married employee.

select CONCAT(f_name, " ", l_name) AS Name,
s_name as 'Spouse Name' from
employee_data, employee_per
where m_status = 'Y' AND
emp_id = e_id;
+-----------------+-----------------+
| Name | Spouse Name |
+-----------------+-----------------+
| Manish Sharma | Anamika Sharma |
| John Hagan | Jane Donner |
| Ganesh Pillai | Sandhya Pillai |
| Anamika Sharma | Manish Sharma |
+-----------------+-----------------+

Because you want to return results from another table you will need to join the tables....