giacomo Posted February 25, 2004 Share Posted February 25, 2004 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 Link to comment Share on other sites More sharing options...
jscooper Posted February 25, 2004 Share Posted February 25, 2004 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," Link to comment Share on other sites More sharing options...
giacomo Posted February 26, 2004 Author Share Posted February 26, 2004 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7364 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now