Could someone give me a suggestion on how to best address the following problem?
I have a page that will allow my users to register for an event. On that page you have the ability to choose up to three upgrades and enter other options for each trip. The options for each of the three upgrade choices is pulled from the same table and I simply store the ID for the option that they choose in their respective field. I have upgrade.Id being stored in registration.upgrade1, registration.upgrade2, and registration.upgrade3. I now need to create a report that will show all of the registrations at once and list out the upgrade options that each person has chosen. Listing out the Ids is no problem but I need to show the descriptions from the upgrades table instead of the id. Currently, I have two queries - one that pulls in their registration information and all of the other associated information (such as their name, address, etc. from the profile table) and one that lists out the upgrade options from the upgrades table. At first I thought I could use a CFCase tag but it will not allow the cfoutput tag within it to auto generate the cfcase options. I've tried some other options but now I'm realizing that I can't use a cfoutput tag with the query attribute inside another cfoutput tag that also uses the query attribute. I'm sure there is an easy solution - I just can't seem to think of one at the moment. Any help would be appreciated. Thanks, Tim ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
