I am writting a site using cf7 and dreamweaver 8. Database tables are
access 2003.
I wrote a query that pulls data from table B that takes only information
that is related to a selection from query A. I run the query, select an
entry from table A and it pulls related records in table B. Results are
good.
My problem is that I am trying to connect the tables to pull down list
boxes
on the website form.
Pull down list A and it shows all the options from table A.. Select an
item
from table A
Pull down list B and it ONLY shows records in table B that have a
reference
in table A.
ex.. pull down A... select... History pull down B shows ONLY English,
American or German
Everything I have tried in dreamweaver to make the connection has failed.
Can anyone give me an idea where to start?
Thanks,
Stephen
