How bout running an onChange event on the entering of the company name.
Have a hidden frame run a query on the database on say the first 2 or 3
letters entered. Populate a select box on the original page with those
companies with one selection being "Keep current company". That way you
would only show those companies with the names similar to those the user is
typing in. They can make their own selection and you would have some sort of
integrity check user side.
Of course I would run something on the Admin side as well to make sure that
they could catch whatever falls through the cracks.
Sandy Clark
Shayna Productions
-----Original Message-----
From: Erika L Walker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 12:39 PM
To: CF-Community
Subject: RE: OT: Data Integrity - Q of the Day
Judith,
The drop-down isn't a solution, as I mentioned, there are far too many
different pharmaceutical companies and divisions for that to happen. We
would be sure of forgetting a company and then somebody would get mad.
So far, I see it having to happen where an admin on the client's side has to
manually massage the data and get it to match.
Thanks for the reply!!!
Erika
(with a *K*)
-----Original Message-----
From: Judith Campbell [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 1:20 PM
To: CF-Community
Subject: Re: OT: Data Integrity - Q of the Day
At 12:06 PM 5/10/01 -0400, you wrote:
>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?
Build a drop down of all the existing companies from the user to pick from,
or a field for them to add their company if it's not on the list.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
