Erika,
Download a copy of CommerceBlocks Explorer from
http://www.CommerceBlocks.com, and use the DatabaseBlocks module to generate
code for two related tables, like the ones you're mentioning. Then take a
look at the way we do a "Filtered Select Menu," which enables you to filter
on the names or parent entities in a child record edit form.
This might not be exactly what you're looking for, but if it is then just
pirate the generated code for your own app.
I look forward to seeing you in the Advanced Bootcamp, and to Dances With
Snoopy.
Respectfully,
Adam Phillip Churvis
Productivity Enhancement, Inc.
Want truly advanced ColdFusion 5 training? Register for the Advanced
Bootcamp for ColdFusion 5, Database, and Javascript at
http://www.ColdFusionTraining.com!
http://www.CommerceBlocks.com
E-mail: [EMAIL PROTECTED]
Phone: 770-446-8866
----- Original Message -----
From: "Erika L Walker" <[EMAIL PROTECTED]>
To: "CF-Community" <[EMAIL PROTECTED]>
Sent: Thursday, May 10, 2001 12:06 PM
Subject: OT: Data Integrity - Q of the Day
> Here's a question that's been bothersome for some time.
>
> We have an interface where participants register for meeting. There is a
> form they fill out with basic information, including the pharmaceutical
> company they are associated with.
>
> We use drop downs where we can to keep data as constant as possible, but
we
> cannot use dropdowns for the company they are with as there are far too
many
> to compile and list.
>
> And therein lies our problem. Users from one company can have a half dozen
> different ways to spell their company name.
>
> There is an admin search page where an administrator can search for
> registered users by several different criteria, one of which is the user's
> company name. I dynamically build a drop down for this field on the search
> page by pulling all distinct company names from the db. Of course, there
are
> several different variations of the company name in the dropdown, which
> makes it very cumbersome.
>
> Has anyone had to deal with this? If so, how did you deal with it? And/or
> does someone have an idea on how to go about dealing with it?
>
>
> Erika
> (with a *K*)
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-community@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists