Indexing Problem

In a PO entry system, I make use of a pull down containing sorted product
names. This is an additional way to select a product other then style
number.
If the Product name field (text) residing in a Product file contains a " - "
the product listing pull down can not see the difference and does not show
it.
Here is an example
Sleeping Bag 0 Degrees
Sleeping Bag -20 Degrees
Sleeping Bag 20 Degrees

Only two of the three will show up in the drop down list. One of the 20
Degree Sleeping bags will be omitted from the pull down. The field on the
layout is formatted as a Pop-up List using Value list (Product Index) The
field is text. Any ideas or a suggestion for a fix. This solution has
been in use for five years without a problem, so it written in FM6 Thanks.
Carl

Re: Indexing Problem

On Dec 5, 4:31 pm, "Carl Mittler" wrote:
> In a PO entry system, I make use of a pull down containing sorted product
> names. This is an additional way to select a product other then style
> number.
> If the Product name field (text) residing in a Product file contains a " - "
> the product listing pull down can not see the difference and does not show
> it.
> Here is an example
> Sleeping Bag 0 Degrees
> Sleeping Bag -20 Degrees
> Sleeping Bag 20 Degrees
>
> Only two of the three will show up in the drop down list. One of the 20
> Degree Sleeping bags will be omitted from the pull down. The field on the
> layout is formatted as a Pop-up List using Value list (Product Index) The
> field is text. Any ideas or a suggestion for a fix. This solution has
> been in use for five years without a problem, so it written in FM6 Thanks.
> Carl

I can't help with the actual issue of "-" not being recognized, but
can you subsititute "minus" instead?

Re: Indexing Problem

"Carl Mittler" wrote in message
news:%wG5j.91$Es3.68@newsfe08.lga...
> In a PO entry system, I make use of a pull down containing sorted product
> names. This is an additional way to select a product other then style
> number.
> If the Product name field (text) residing in a Product file contains a " -
> " the product listing pull down can not see the difference and does not
> show it.
> Here is an example
> Sleeping Bag 0 Degrees
> Sleeping Bag -20 Degrees
> Sleeping Bag 20 Degrees
>
> Only two of the three will show up in the drop down list. One of the 20
> Degree Sleeping bags will be omitted from the pull down. The field on
> the layout is formatted as a Pop-up List using Value list (Product Index)
> The field is text. Any ideas or a suggestion for a fix. This solution
> has been in use for five years without a problem, so it written in FM6
> Thanks.
> Carl
Hey Carl- et. all

I tested this on FMP 9.0 Adv / Windows
And couldn't reproduce the problem. I tested four permutation: Pop Up menu
and Drop Down list using values from a Text field and a Custom list- it
worked fine for me.? Maybe it's a version issue?

Conrad

Re: Indexing Problem

In article ,
"Conrad Lorda" wrote:

> "Carl Mittler" wrote in message
> news:%wG5j.91$Es3.68@newsfe08.lga...
> > In a PO entry system, I make use of a pull down containing sorted product
> > names. This is an additional way to select a product other then style
> > number.
> > If the Product name field (text) residing in a Product file contains a " -
> > " the product listing pull down can not see the difference and does not
> > show it.
> > Here is an example
> > Sleeping Bag 0 Degrees
> > Sleeping Bag -20 Degrees
> > Sleeping Bag 20 Degrees
> >
> > Only two of the three will show up in the drop down list. One of the 20
> > Degree Sleeping bags will be omitted from the pull down. The field on
> > the layout is formatted as a Pop-up List using Value list (Product Index)
> > The field is text. Any ideas or a suggestion for a fix. This solution
> > has been in use for five years without a problem, so it written in FM6
> > Thanks.
> > Carl
> Hey Carl- et. all
>
> I tested this on FMP 9.0 Adv / Windows
> And couldn't reproduce the problem. I tested four permutation: Pop Up menu
> and Drop Down list using values from a Text field and a Custom list- it
> worked fine for me.? Maybe it's a version issue?
>
> Conrad

A value list based on a field depends on the indexing of the field. The
indexing can get corrupted.

Two ways to correct the indexing:

1. In the field definition, change the indexing from whatever it is to
another setting, then use the value list, then if needed change the
indexing back again. That forces the field to re-index.

2. Save the database as a compacted copy. Compacting forces reindexing
of all indexes, including internal indexes of the storage blocks as well
as the indexes of fields, and so corrects a variety of corruptions.

--
Bill Collins
For email, change "fake" to "earthlink"

Re: Indexing Problem

On 2007-12-05 15:31:07 -0800, "Carl Mittler" said:

> In a PO entry system, I make use of a pull down containing sorted product
> names. This is an additional way to select a product other then style
> number.
> If the Product name field (text) residing in a Product file contains a " - "
> the product listing pull down can not see the difference and does not show
> it.
> Here is an example
> Sleeping Bag 0 Degrees
> Sleeping Bag -20 Degrees
> Sleeping Bag 20 Degrees
>
> Only two of the three will show up in the drop down list. One of the 20
> Degree Sleeping bags will be omitted from the pull down. The field on the
> layout is formatted as a Pop-up List using Value list (Product Index) The
> field is text. Any ideas or a suggestion for a fix. This solution has
> been in use for five years without a problem, so it written in FM6 Thanks.
> Carl

I suspect you're indexing that field in English, and "-" isn't an
English-indexed character. It's a word-delimiter.

So the field isn't recognizing "20" and "-20" as distinct entries. Try
going to the field def, Options, and specifying ASCII as the indexing
for the field. (If you were using FM7+, it would be Unicode)

That might fix your problem. Otherwise change the "-20" to "Neg 20" or
something to get the value list to appear properly.
--
Lynn Allen
--
www.semiotics.com
Member Filemaker Business Alliance
Long Beach, CA