Help with Checkboxes

[Maria Tique]

Please help!!!

I have 3 textboxes: txt1 and txt2 and txt3

I also have a checkbox with values of Red, Blue, and Green.

Problem and Question:

When the user checks Red, Blue, or Green in the checkbox then txt1 and txt2 and txt3 should remain empty with no data. How do i do this? Do i create a calculation in define database or do i have to create a script and if so what do i write?

Please help help help. I am new to this.

[Inky Phil]

Hello Maria

I am a newcomer to 7 myself so maybe I am not the best person to help you but I tried to solve your problem and could not find a way to validate or calculate the result that you wanted. Please remember that this does not mean there isn't a way.

In the absence of anyone else diving in with a proper solution you could use a script along the lines of

If not IsEmpty(Your checkbox)

Set field txt1,""

Set field txt2,""

Set field txt3,""

endif

If you attach this script to a button ( maybe the one that leaves that paricular layout) it would empty the txt fields in the case of the checkbox field having anything in it.

Hope that helps

Phil

[Maria Tique]

Hi Phil,

Thank you a million....Your code worked, i had trouble however trying to find out how to and where to input the "" but got it to work thanks to you. Thank you so so so so much. I am jumping for joy.

Can i ask you, what books you recommend. I bought the 2 books but would like your feedback. So far i have Filemaker pro 7 bible, and sams teachyourself in 24 hours. Any other books you can suggest? I am in Miami and not to many people here work with filemaker. Thats my opinion.

[Inky Phil]

Maria,

I am so glad that I was able to be of help.

I have had so much help from this and other forums and it is so frustrating that, being a relative beginner, I cannot help others the way I have been helped so I got as much from your reply as you did from my answer.

Now, with regard to the books. I only have the bible which I find gives you all the basics but, as you have discovered, does not always help when you have a specific problem to solve. I think this must be the case with most books cos of course they will never know the context of the problem that you have to solve at any given moment. The answer is probably in there somewhere but under a heading (or two or three) that appears totally unrelated to your specific problem.

FM is akin to a jigsaw puzzle - all the pieces are in the box but the fun is in putting those pieces together to give you something that makes sense. Also the more pieces you get into place the easier it becomes. That is where the forums come in.

You are very fortunate in having found this particular forum. It is by far the best around. The wealth of knowledge available in here has to be experienced to be believed and the people in here are so willing to share, both their experience and their time.

I find that most questions are answered promptly (sooner than one would expect usually) and with no limit to follow up questions. The people are incredibly patient at talking people through their problems and it does not matter how simple or complex the question. You could for instance have asked about how and where do you get the ""'s from. Someone would have jumped in and helped - probably within minutes. So I say dive in here as often as you need, the water's lovely!!!

Regards

Phil

[-Queue-]

You can also make your txtN fields auto-enter calculations with 'do not replace existing value' deselected, equal to

If( IsEmpty(checkbox); txtN )

where N is 1 for the first field, 2 for the second, 3 for the third. When checkbox has a value, anything entered into these three fields will be removed. When checkbox is empty, the fields will retain newly entered values.

[Inky Phil]

Appreciate that tip Queue. I knew there would be another way other than scripting.

Regards

Phil :