08-12-2008 12:51 AM
Is it possible to create a lookup and then replace a Yes/No field value from no checkmark (no) to a checkmark (yes)? I can't figure out how to do it. I'm assuming that because it pulls down in the menu as a field to replace, it must be possible. Am I suppose to use a special character? I've tried several. Nothing has worked.
08-12-2008 04:55 AM
Create a lookup of all "No" values.
Then click Edit from the pull-down menu, then "Replace Data"", and then select the checkbox field on the left you wish to change, and then type TRUE".
Obviously this process is reversed for clearing a lookup of checked boxes.
Hope this helps.