RE: OT: Data Integrity - Q of the Day

2001-05-11 Thread Sandra Clark
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 a

RE: Data Integrity - Q of the Day

2001-05-11 Thread Guy McDowell
IL PROTECTED] Subject: OT: Data Integrity - Q of the Day Message-ID: <[EMAIL PROTECTED]> 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 phar

RE: Data Integrity - Q of the Day

2001-05-10 Thread Judith Taylor
I believe you can, but wouldn't it make sense to have it create the collection with more than just the name, say maybe the address as well? I know that people are supposed to know everything about the company they work for, but when they start either spelling it wrong, or put in different name

RE: Data Integrity - Q of the Day

2001-05-10 Thread Erika L Walker
Message- From: Judith Taylor [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 8:25 PM To: CF-Community Subject: Re: Data Integrity - Q of the Day Well, if you're going to do that, why not use Verity to create a collection of all the company namesessentially you're needing

Re: Data Integrity - Q of the Day

2001-05-10 Thread Judith Taylor
Well, if you're going to do that, why not use Verity to create a collection of all the company namesessentially you're needing to search your database for all existing variations of a company name and using Verity reduces the load/hit to your DB. Just a thought. The Other Judith Daryl Wa

Re: Data Integrity - Q of the Day

2001-05-10 Thread Daryl Walsh
em to a separate page entirely. - Original Message - From: "Erika L Walker" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 11:06 AM Subject: OT: Data Integrity - Q of the Day > Here's a question that's

RE: OT: Data Integrity - Q of the Day

2001-05-10 Thread Erika L Walker
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

Re: OT: Data Integrity - Q of the Day

2001-05-10 Thread Craig S. Kiessling
Another good idea might be to shout out loud "Sing--Me--A--Sooong--For--Daaddy, Oh, Sing--Me--A--Song..." - Original Message - From: "Judith Campbell" <[EMAIL PROTECTED]> To: "CF-Community" <[EMAIL PROTECTED]> Sent: Thursday, May 10, 2001 1

RE: Data Integrity - Q of the Day

2001-05-10 Thread Daniel Dewey
er [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 12:07 PM To: CF-Community 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 in

Re: OT: Data Integrity - Q of the Day

2001-05-10 Thread Judith Campbell
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

Re: OT: Data Integrity - Q of the Day

2001-05-10 Thread Tobe Goldfinger
when I have situations like this and there seems no other way around the problem.. what I do is put 2 fields on the record the first one to hold the company name the way it was entered and a second one that is initialized to that user-entered data. but the administrator has a screen wh

Re: Data Integrity - Q of the Day

2001-05-10 Thread Adam Phillip Churvis
l 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 in

OT: Data Integrity - Q of the Day

2001-05-10 Thread Erika L Walker
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 po