No need for IFRAME's. Simply use javascript to trigger an onchange event in the student drop-down. The event should locate the browser to the same page, with a URL parameter consisting of at least the student ID that was chosen. Query for the data for this student, then, underneath the drop-down, simply display the data results of the selected student.
Mike -----Original Message----- From: Andy McDuff [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 18, 2006 2:27 PM To: CF-Talk Subject: One-to-many application on one screen Hi there, I'm relatively new to CF (although Ben's WACK book is being throughly digested) but fine with SQL, DB design and no problems on general coding. I'm working on a small test app to display courses being attended by students. The idea is to put everything on one single HTML page. At the top of the page would appear a drop-down list of students (retrieved via cfselect tag & SQL from a CFC), and on the bottom-half of the screen would appear the courses being or have been attended. There are 3 tables: student, course and student-course (many-to-many relationship broken out to two sets of 1-to-many), student-course being the link table. Nothing fancy for the moment... What's the best way to do this? Use IFRAME's? If so, what's the general approach? How do I pass the selected student (from the top frame) in order to query the courses and display them in the bottom-half of the screen (without having to use a button)? Is this done via Javascript or can this be done via CF? Any help / guidance / pseudo-code would be gratefully appreciated. Andy McDuff Madrid, Spain ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246970 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
