Is there a way to make a particular field entry accessible or inacessible based on another flag field? Or better yet, is it possible to make layout items disappear or appear based on the flag?

Let me try to explain. I have a layout on which a user will check "Yes" or "No" on a flag field with radio buttons.

What I would like to do is make another field box either disappear or become inacessible in browse mode if the flag field is "No", and conversely appear or become accessible if the flag is "Yes".

However, I'm not sure how to approach this problem. Any nudge in the right direction would be most appreciated.

To make it disappear place a calculation field above it of the type "container". If the flag field = "no", the calculation will set it to the contents of a container field with storage set to global (I keep these types of global fields in a separate table). That field should be filled with a rectangle of the same colour as the background of the field you want to disappear.

On your original layout make that calculation field (container) a button by attaching a script to it: if flag = "yes" go to ...Name of field beneath the calculation/container field.

The field will be both invisible and inaccessible when the flag field is set to No, and visible and accessible when it is set to Yes.

Edited May 25, 200718 yr by Guest

You may want to check out the links that I posted here.

Visibilty Trick

thanks guys, these were most helpful.