The great thing about value lists is that it automaticly removes multiple instances from the value list.

But, now i have a need to keep multiple instances in my value list. Even more, i also want the list to be sorted alphanuerical (not ASCII).

Suppose the relation that is used delivers the following records to the valuelist:

aaa

bbb

ccc

ddd

eee

aaa

ddd

Normaly the valuelist would be

aaa

bbb

ccc

ddd

eee

but now i want to be the value list

aaa

ddd

aaa

bbb

ccc

ddd

eee

Does anyone know how to achieve this in FMP 5.5

Thanks a lot

Jitse Schaafsma

I guess you can manually create the list. Big question here is Why do you want duplicates in the lists?

Lee

Thanks Lee,

To answer the why Q ( and why manually is not an option).

The value list contains materials that clients can order.

Now i want to include in the value list the materials that clients previously have ordered and

all the materials that are available.

So for each client the value list will be different and manualy filling is not a option.

I the example i have used:

The user of the database is taking order of a client.

This client has previously ordered aaa and ddd.

Now suppose the clients orders aaa and ccc.

Then the next time this clients makes an order

the value list should be

aaa

ccc

ddd.

Any ideas

Jitse