Index problems

[Nancy Palmquist]

Tim Fischer wrote:

> John Esak wrote:
> 
>>Okay, I tried that and got the record again... but a little 
>>differntly...
>>
>>      C&P TELEPHONE
>>      FRED'S FISH MARKET                 FFF
>>      FRED'S FISH MARKET                 FFF
>>
>>
>>which, at least, shows that I did retrieve the record in its 
>>proer order in the index... but becuase the 2nd field isn't 
>>filled it no longer resides in the index... I guess that 
>>makes sense.  Could there be any corrupted data in your file? 
>>Something in the field that shouldn't be?
>>
>>Stupid question... are you by any chance building the index 
>>just on T) ???
>>Because if you are, this is wrong. That would be really T0)  
>>and not T1).
>>Just a thought.
>>
>>John
>>
> 
> 
> Hi John,
> 
> I definitely built the index on T1) - I just double, nay triple checked it.
> 
> What do you mean by something in the field that shouldn't be?  The field
> "looks" right when viewed on-screen.  And do you mean corrupted data in my
> index or in my file?  I've rebuilt the index several times with no change.
> As for the file, I guess anything is possible - do you have a good way I can
> check this?

I have used associated fields for many things and an index such as you 
have designed works fine in all my tests.  John demonstrated the results 
perfectly.

What I did not see was what version of filePro you are using?

I only have two suggestions, if the version is 5.0, 1) is to say delete 
the index and build it fresh, 2) Make sure the first character in the 
field is text and not a space.

If the version is older - get it upgraded.

Nancy
-- 
Nancy Palmquist
Virtual Software Systems
PHONE: (412) 835-9417			Web site:  http://www.vss3.com