In my FMP (5.0v1) database I want to have a radio button to allow the
input of 3 mutually exclusive choices like shown below:
_ _ _
( ) Choice1 (.) Choice2 ( ) Choice3
Now, when a user makes a selection I don't want to store the text
corresponding to the choices description in each record as that will be
just a waste of space and make searches and calculations not so easy.
Hence, in my database I have just one numeric field, say Choice_ID that
is mapped to a small file containing also a field called Choice_ID and
another with the corresponding the description, e.g.
"main_database.fp5" "choice_desc.fp5"
+-----------+ +-----------+---------------------+
.......| Choice_ID | -----> | Choice_ID | Choice_description |
+-----------+ +-----------+---------------------+
Now in my main database I create a field, format it to be radio button
and specify the value list to be in "choice_desc.fp5". It works fine (as
explained above) but it displays also the numeric value, which is
irrelevant for the user. This is, what I get is:
_ _ _
( ) 1 Choice1 (.) 2 Choice2 ( ) 3 Choice3
^^^ ^^^ ^^^
^^^ = Irrelevant information for the user
My question is:
Is it possible to tell FMP not to print the numeric field on the radio
button?
Thanks.
Tony F.