Index problems
Tim Fischer
tim.fischer at trinitytransport.com
Wed Aug 11 06:06:41 PDT 2004
John Esak wrote:
> Well, I am SO bad at figuring out complex asociated field
> things... but when I started to try and duplicate your
> problem, I realized that I didn't understand the design
> enough to copy it. What do you mean by
>
> > I have an index built on an associated field (T1) which is built
> > around 2 text fields (both are 30,ALLUP). When searching
> through this
> > index, I'm
>
> I am assuming there are two fields 30,allup in the associated
> field group,
> like:
>
> t1) name 30 allup
> t1) name 30 allup
This is exactly how it's setup. Sorry I wasn't more clear.
>
> and you have built the index on t1) for 30 characters, right?
>
Yes, the index is built on 30 characters.
> If this is so, when I did it and added two records:
>
>
> record 1)
> T1) CHESAPEAKE & POTOMAC TELEPHONE
> T1) C&P
>
> Record 2)
> T1) FRED'S FISH MARKET
> T1) FFF
>
> and then searched by index for c&p, it came right up in this
> order (in the IUA browse)
>
>
> CHESAPEAKE & POTOMAC TELEPHONE C&P
> CHESAPEAKE & POTOMAC TELEPHONE C&P
> FRED'S FISH MARKET FFF
> FRED'S FISH MARKET FFF
>
> which is a long-about way of saying I couldn't duplicate your
> problem. But, I did try. Maybe someone else will have some
> insight on this.
>
> John
This is close, but try this setup:
record 1)
T1) C&P TELEPHONE
T1)
Record 2)
T1) FRED'S FISH MARKET
T1) FFF
I think that the problem has something to do with the 2nd field being blank.
This is just a guess, but I can't think of any other reason for this.
Thanks again!
Tim Fischer
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.736 / Virus Database: 490 - Release Date: 8/9/2004
More information about the Filepro-list
mailing list