Hi Becky,
<!---
i like the tag cf_twoselectsrelated. but i want to be able to choose
fro
m either the first or the second drop-down.
i have two different selects to be filled. one for companies, the other
for applications.
if i choose the first select for company and i choose macromedia...in
the
second select i would see coldfusion, flash, etc...
but what if i wanted to do the reverse? i want to be able to choose the
application then have the company change to the correct one.
has anyone done this before?
any help appreciated.
thanks,
bec.
--->
I think you should use another CF_Twoselectsrelated tag, with the query
columns reversed. I have a modified tag that allows for multiple uses
on the same page.
The scenario where it works both ways would be rather confusing, but not
impossible, if and only if the product(s) can exist in more than one
company category i.e.
Box 1 Box 2
Kroger Bread
Circle K Gas
Merita Bread Company Cinnamon Rolls
Exxon Oil Soft Drink
If you choose something out of the box 1 column, then it corresponds to
a box 2 product, which then corresponds to a box 1 column...
Working solution:
Box 1: Kroger
Box 2: Bread, Cinnamon Rolls, Soft Drink
Box 2: Bread
Box 1: Circle K, Kroger, Merita Bread Company
Box 1: Merita Bread Company
Box 2: Bread
Box 2: Bread
Box 1: Circle K, Kroger, Merita Bread Company
Box 1: Circle K
Box 2: Gas, Bread, Cinnamon Rolls, Soft Drink
Box 2: Gas
Box 1: Circle K, Exxon
The problem with a situation like this is if you drill to a product or
series of products that is or are made by only one company
- say Cold Fusion - the company box will be filled with only one company
- say Macromedia - , and then the choices will no long repopulate with
all the necessary choices.
Non working solution:
Box 1 Box 2
Macromedia Flash
Microsoft Coldfusion
OtherCompany ASP
Other Product
Box 1: Macromedia
Box 2: Flash, Cold Fusion
Box 2: Flash
Box 1: Macromedia
It ends right at the first selection.
I hope that this explanation is helpful and not unnecessarily long.
- Matt Small
-----Original Message-----
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 4:33 PM
To: CF-Talk
Subject: combo boxes
i like the tag cf_twoselectsrelated. but i want to be able to choose
fro
m either the first or the second drop-down.
i have two different selects to be filled. one for companies, the other
for applications.
if i choose the first select for company and i choose macromedia...in
the
second select i would see coldfusion, flash, etc...
but what if i wanted to do the reverse? i want to be able to choose the
application then have the company change to the correct one.
has anyone done this before?
any help appreciated.
thanks,
bec.
*************************************************
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
