Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old January 4th, 2006, 10:54 PM
Authorized User
 
Join Date: Jan 2006
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default Data Retrival

I have a problem here. I have a database with 3 tables in it.(Imagine as there are 3 levels, one level for each table)

on level 1, there are 3 entries:A,B,C

on level 2, the entries are tied to one of the entries in level 1, ie those in level 2 will be A.1, A.2, A.3, B.1,B.2,C.1,C.2.....

on level 3, the entries are tied to one of the entries in level 2, ie those in level 3 will be A.1.1, A.1.2, A.1.3, A.2.1,A.2.2,B.1.2,C.2.1.....

I have 3 combo boxes on my webpage. I want it to be able to do the following:

when i make my choice on combobox 1 which holds the information of level 1, only those entries corresponding to the choice made in combobox1. ie if in combobox 1, i chose A, then i only wan those of A.1,A.2,A.3 to be shown in combobox 2.... after which, say I choose A.1 in combobox 2, I only wan those of A.1.1, A.1.2,A.1.3 to be shown in combobox 3.

Is this achievable in asp and sql since it sort of requires dynamic programming?

thanks for any inputs.




Similar Threads
Thread Thread Starter Forum Replies Last Post
asp 3.0 classic&access *formula retrival)? saad_rashad Classic ASP Databases 3 February 18th, 2007 03:47 PM
Data Retrival xbenx Classic ASP Basics 22 January 18th, 2006 06:17 PM
Retrival of Server Side DateTime with ACCESS dubey.kuldeep Access 2 November 1st, 2005 12:37 PM
retrival of decrypted data msrnivas General .NET 0 December 7th, 2004 02:52 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.