lookup field

[Kenneth Brody]

On 3/14/2011 5:14 PM, Ken Cole wrote:
> Or the variable is carrying it's value
> over from one record to the next!

I thought of that, but I consider that part of #1.  But, until we hear back 
from Richard, we can only guess.

[...]
>> Again, the single line of code you posted will only set IsNewYork to "Y" if
>> the first 2 characters of foobar(34) are "ny".
>>
>> So, the possibilities I see are:
>>
>> 1) Something else in your code can also set IsNewYork.
>>
>> 2) The code to create the new record can be executed even if IsNewYork is
>> not "Y".
>>
>> 3) You are mistaken in your belief that any records are being erroneously
>> created in the first place.
[...]

-- 
Kenneth Brody