Assuming you have all the cities and which region they are in in a table in the database, just do a select statement using the region as the where clause and setting it to the user's region, using the resulting data to create the drop down. Or am I missing the point?
Dan ________________________________ From: Grinwald, Uri [mailto:[EMAIL PROTECTED] Sent: 09 December 2004 15:58 To: [EMAIL PROTECTED] Subject: RE: [AspClassicAnyQuestionIsOk] New Birthday Calendar Hello. I was wondering how the best way to approach the following. Using a combination of access and ASP how can I create a dropdown with say 10 cities, and depending on the user at that time show only those specific cities pertaing to his or her region? Thanks in advance Uri Yahoo! Groups Sponsor ADVERTISEMENT click here <http://us.ard.yahoo.com/SIG=12999mtep/M=294855.5468653.6549235.3001176/ D=groups/S=1705006764:HM/EXP=1102694268/A=2455396/R=0/SIG=119u9qmi7/*htt p:/smallbusiness.yahoo.com/domains/> <http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group s/S=:HM/A=2455396/rand=952421772> ________________________________ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] subscribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
