Field available by contents of another?

[RobK68]

Is it possible to create a field that is only visible or editable when another field has a certain value?

I.E. If a radio box field has the 1st item selected the field beneath would allow another radio box field to be editable otherwise it would be unavailable.

Thanks,

Rob

[-Queue-]

You can use the visibility technique. There may be an easier method with v7, but I have yet to see it.

Create a calculation number field flag|edit|fieldB equal to fieldA = "desiredValue" and a calculation number field constant equal to 1. Create a self-relationship from flag|edit|fieldB to constant. Put a portal on your layout that uses this relationship and displays one record only, has no borders or fill color, and is one pixel larger than the border of fieldB. Then put fieldB inside the portal.

Now the relationship will only be valid and fieldB will appear when fieldA equals desiredValue.