FM 8.5 Adv, win XP

When I create a value list with unchanging values, I enter them manually in
the valuelist defnition window.
When I want a changing set I use a table (or a related table).

With predefined value lists I enter the values I need in the order I want,
seperated by a line when needed.
The problem arises when I want the same behavior, but now through a list in
a table.

When I enter the values (one record per value):

One
Two
Three
Zero
-
Banana
Apple

I want to keep the order like that. It now appears as:
-
Apple
Banana
One
Three
Two
Zero

The sorting order is disabled.

And on top of this I would like to be able to give different colors to
different parts within one value list. Say blue to the numbers and dark-red
to the fruit.

Ursus

In article <453b5ee0$0$53786$dbd4b001 (AT) news (DOT) wanadoo.nl>,
"Ursus" <ursus.kirk (AT) wanadoo (DOT) nl> wrote:

Not much choice here.

You can control the order if you "hardwire" the list manually. FileMaker
will sort it if you use a list derived from a field. Just the way it is.

The colors thing is interesting. I don't see any way to change the color
of a value list unless you change the color of the field. You could
script a change to the field's attributes (which would result in a
change to the dropdown/popup), perhaps using EventScript or zippScript
to execute automatically, but I don't see any way to have multiple
colors in a single field as you suggest.

M

M

You can force a certain sort order in this situation by using a second
field, a number field, with the sort priority. Kind of like line numbers in
a BASIC program. For value lists, use the technique of sorting by the
numeric field but showing the second field. Either at the value list level
or the relationship level.

"Matt Wills" <Im (AT) Witz (DOT) End> wrote