lookup field

[Richard Kreiss]

I have a lookup to a 60 character field which was originally to hold a name.
As my client never used that field for this purpose, we decided to use it to
hold a "NY" to indicate the person associated was in New York.  Yes, there
is a state field with NY, but this is a subset of those, plus some in either
new jersey or Conn. Can be part of the NY subset.

 

My program checks

If: foobar(34)="Ny"

Then: IsNewYork="Y"

 

This allow branching to handle those records in this subset.  However I am
getting records posted that are not part of the NY subset.

 

Since they do not want me to resize the field I need to do one of these in
my program.

 

If: mid(foobar(34),"1",'2"0="NY"

Then: IsNewYork="Y"

 

Or  

 

If:

Then: ny(2,*)=foobar(34)

If: ny="Ny"

Then:isNewYork="Y"

 

My thought is to use option 1.

 

More to the question, foobar(34) is blank in all records except for those in
the NY subset.  Why would IsNewYork be set if foobar(34) is blank?

 

Richard kreiss

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20110312/558d59d0/attachment.html