I want the value list that I have created to show the user. "Active"
or "Complete" but when selected I want Filemaker to see "1" or "0". Is
this possible with FMP7 ?

-S

squeed2000 (AT) yahoo (DOT) com wrote:

You're not going to get a field to show one value but actually be another.
The value is the value is the value.

What you can do is create a calculation field that reflects the value you
want in one field according to the selection in another:

YourValue = If [ Selection = "Active" ; 1 ; 0 )

or perhaps

YourValue = Case (

Selection = "Active" ; 1 ;

Selection = "Complete" ; 0

)

Matt

In your existing files create a new table called "Values".
Create 2 fields in the table "Number" and "Display Text".
Create 2 records in the table;
1 Active
0 Complete
Create a new valuelist which displays both the "Number" & "Display
Text" fields.
The user will see the options;
1 Active
0 Complete
but only the number is entered into the FMP field upon selection.

In article <epuMe.436$zb.187@trndny03>, "Matt Wills" <I'm (AT) Witz (DOT) end>
wrote:

If the field displaying the Value list is using Checkboxe or Radio
Button format, then you can simply define the Value List itself as 0
and 1, then shrink the width of the field so that only the checkboxes /
radio buttons are displayed, and retype the visual labels "Active" and
"Complete" using a normal Text element and postition them next to the
checkbox / radio button.
eg.

[] {0} Active
[] {1} Complete

where {} means the number is hidden by shrinking the field width.




Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)