Very Computer

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.

Case(Choice_ID = Choice1, 1,
         Choice_ID = Choice2, 2,
         Choice_ID = Choice3, 3
         )

..., or some similar scheme? Any reason you can't hard-code the value list?

FMP will print, to answer your question, whatever the field is formatted to
print. It's common practice to use a different layout for printing than for
data input, and that layout can display the field without its radio button.

--
John Weinshel
Datagrace
Vashon Island, WA
(206) 463-1634
Associate Member, Filemaker Solutions Alliance

Quote:> 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.

Hope I understood your problem correctly

Rienk

Quote:> 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.

Quote:> FMP will print, to answer your question, whatever the field is formatted to
> print. It's common practice to use a different layout for printing than for
> data input, and that layout can display the field without its radio button.

Tony F.

Though not an elegant solution, I did make the font colour equal to the
radio button background colour and put 3 textboxes to label the radio
buttons field.

Afterwards, I went to browse mode but when I clicked on the field the
textboxes disappeared "underneath" resulting in the radio button having
no labels. Maybe it is possible to change this behaviour but I could
find how to do it.

Tony F.

then that trick does not seem to work (if you shrink the radio button
field only the leftmost button will be visible).

Tony F.

Hi Tony,

If you want to resize those pesky radio buttons - have them horizontal
but further apart, and still 'not' display the label, you can do so.
The following will allow you room to place your text:

Create a Value List for each selection in the radio button.  VL with
'1',  VL with '2' etc.

Place your real radio button field on the form in three places.  Resize
the radio so only the radio displays.  Copy it twice more.  Attach the
new Value Lists - VL1 to the first field, VL2 to second and VL3 to third
as radios.

Now you can place them anywhere but they fill the same field.  Also
works with checkboxes.   BTW, VL's take very little FM resources. :)

I had to place M/F checkboxes on a pre-printed government form (Medicaid
HCFA1500) and spread them apart but not show the labels.  This works
very well.

LaRetta

--
Posted via http://dbforums.com

Thanks a lot for your suggestion. It now works as I wanted.

Tony F.