Michael
Don Codling wrote:
December 5, 2006I assume you have missed something or have something complicating your result, because I can go up and down the row and it changes every time I enter "Y" in a new button.P1F4 formula IF (P1F5 = "Y") OR (P1F6 = "Y") THEN "" ELSE "Y" ENDIF P1F5 formula IF (P1F4 = "Y") OR (P1F6 = "Y") THEN "" ELSE "Y" ENDIF P1F6 formula IF (P1F4 = "Y") OR (P1F5 = "Y") THEN "" ELSE "Y" ENDIFI have done this in some data bases with the alternative to "Y" being "N" rather than a blank. It's quite flexible that way.As well each of them is set to "Initialize at Create/Save/Change", so it changes immediately a choice is made. After the first record, that means that Radio button 1, P1F4, is initially selected, but then another selection returns that to blank.The first button I touch in the first record, I can put anything in it, and get "Y". Thereafter, buttons will only accept a "Y".To make a change after a record has been saved, you have to go to edit, which means your first key stroke won't do anything.Don Codling WP 12.0.0.602 DP 2.6x Windows XP home, SP2 512 MBytes RAM Michael Iannantuoni wrote:Thanks Don,That works OK up to a point: the problem I have is that if P1F6 is set to "Y", it must be unchecked before either of the two can be checked or am I doing something wrong?Michael Don Codling wrote:December 5, 2006If by radio buttons you mean fields in which if one is on the others are off, it seems fairly simple to me, perhaps because I deal in simple structures.I have created a test database which has U1 fields P1F4, P1F5 and P1F6. Each of them has a formula associated with it, in this form (for P1F4) IF (P1F5 = "Y") OR (P1F6 = "Y") THEN "" ELSE "Y" ENDIF these are set to change when modified.If you enter anything in any one of them, it reads "Y", and the others switch to "".Don Codling WP 12.0.0.602 DP 2.6x Windows XP home, SP2 512 MBytes RAM Michael Iannantuoni wrote:Hi Brian, I have a sort of solution for radio buttons: Each of my check boxes are U1 fields.To their right is a label field which has a "]" & the response Question Wording and to the right of that a GZ field which is 1 if the U1 is "X" otherwise 0. Another field sums the GZ's to keep a tally of how many boxes have been checked.To the left of the U1 fields is a conditional A1 field which is either ASCII 249 or "[".If the selection is multiple option, any available boxes can be checked.If the option is Lickert, once a box has been checked, the "[" associated with the other boxes turn to ASCII 249 so no further entry is possible.If the user changes their mind, they must uncheck the checked box which then changes all the other conditional A1 fields back to "[" thus allowing any to be selected again.OK, not quite Radio Buttons but only one check box is allowed as per Lickert.What do you think? Michael _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
Test.str
Description: Binary data
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
