2 Related Combos

[jazz823]

I downloaded the 2 selects related combos and have some issues. How can i use that script when both combo boxes pull from the database. I have one combo box that contains insurance companies, and when one is chosen I want the next combo box only to have address that relate to that ins company.

There are two tables one from ins companies and one for locations and they are related by an id field. Any help would be appreciated. Thanks
JIm

[CF_Oracle]

Read this http://www.arescom.com/Arescom/Arescom_2002/Solutions/CF_TwoSelectsRelated.html
We used this custom tag and it works. Good luck.

[jazz823]

Thanks, I did read that originaly and it looks like they hard coded the data, and it does not pull from the DB. so what do i do with the newopt(0) in ths cript to make that pull from the DB.

Thanks

[CF_Oracle]

Duplicate.

[CF_Oracle]

Oops. Duplicate again.

[CF_Oracle]

Again duplicate.

[CF_Oracle]

It could be hard-coded in list or dynamic in query like this:
SELECT a_NAME,
a_ID,
b_name,
b_ID
FROM table1,
table2
WHERE table1.a_ID = table2.a_ID
ORDER BY a_name, b_name

Then call <cf_twoselectsrelated
QUERY="q1"
NAME1="a_ID"
NAME2="b_ID" DISPLAY1="a_Name"
DISPLAY2="b__Name"
VALUE1="a_ID"
VALUE2="b_ID"