Hi,

I'm a new FMP user: I would like to create a db in which I insert a number (N) in a field and automatically N checkboxes are created, with a name from 1 to N.

For instance, if in the FIELD1 I put the number "10", I would like to obtain 10 checkboxes, named from 1 to 10. Moreover, is it possible to convert number to text, like 1=A, 2=B and so on? And, finally, how can I associate an action to a single checkbox, like, for instance, showing me a sub-category when I select one particular checkbox?

Thanks a lot,

Ciao

There are several ways to do this. Here's one that should work with a relatively small number of possible checkboxes:

You can make a dynamic value list to display a different number of checkboxes. Make a new file called "CheckboxNumbers" in it add

CheckboxValues - text field

Number - calculation = patterncount(checkboxvalues,"

Thanks a lot,

I had some difficulties to follow every point, but finally it works!

Since you're so kind, I ask you an answer for another problem:

now I have a field with N checkbox, and an other one with M checkbox (meaning, for instance, 1to 10 checkbox in FIELD1 and A to F in FIELD2).

What I want, now, is that FMP creates automatically N FIELD2, each of which independent, otherwise if I check, for instance, "C", in one, then all others C result checked.

For instance:

FIELD1 FIELD2

1 XA B XC D E F

2 A XB C XD E F

3 A B XC XD XE F

.. .............

.. .............

.. .............

P.S. X indicates that the letter is checked :-)

I hope I explain what I would like to obtain.

Thanks for your helpful tips!

Ciao