May 30, 200718 yr I have a field that is a Yes or No Radio button. I am using the visibility trick to show or hide some items in a portal. It works well, except that if you make an entry to the Yes or No radio buttons, you then have to click somewhere else on the layout to commit the record, and thus show or hide the items in the portal. This will do, I guess, but my preference would be that a click on either radio button would automatically commit the record, thus revealing or concealing the objects in the portal immediately. If anyone has a notion of how I might accomplish this I'd be interested to hear about it.
May 30, 200718 yr Make the field a button that runs a script. The script will toggle the field and commit.
May 30, 200718 yr Author perfect. this site is such a tremendous resource to somebody such as myself that is trying to struggle through the learning process. once again, thanks.
June 1, 200718 yr Author Or use seperate radio buttons for each choice. v7 example attached. sbg2, I have a question for you. I have implemented your elegant solution into my database and it works beautifully. However, there is something I did not quite understand about it. On your relationships graph you had two occurrences of the Graphics table, one of which was relating the Graphics table primary key to the yes boolean in the Commit table. Was this a 'typo'? What purpose did it serve? I've removed that relationship and the second occurrence of the Graphics table from my solution, and everything still seems to work fine. I am just trying to understand what these other things were about. Thanks.
Create an account or sign in to comment