Hi,
I have an Access DB with the following:
tbldis - dis_id, dis_name, dis_phone, dis_city and dis_state
tblstate - id, state_name
I have made a page that lists all distributors (over 100), Grouped/ordered
by state, then city and then distributor name. At present the page lists
'all' distributors by default. What I would like to do is to add the ability
for the user to select an individual state from a dropdown menu and pull up
the distributors for only a specific state, if they so choose.
I only use tblstate to populate a dropdown on the insert form and update
forms in the admin interface. This puts the actual state_name, rather than
an ID in tbldis during an update or insert.
As things stand, is it possible for me to accomplish what I want and if so
could you provide an example. If not what changes will I have to make to my
DB in order to make this work.
Thanks,
Mike
============================================
Michael Wilson - CTO/Secretary
http://www.xionmedia.com
--------------------------------------------
Xion Media, Inc. Web Development
P: 704-398-2454 F: 704-398-2063
============================================
"In the middle of difficulty lies opportunity." --Albert Einstein
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
