Hi Jason
You can do this by setting a temporary DO integer field to 0, then setting the column to the value of the integer field. To clear the checkbox, just set the column to $NULL$ HTH David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== ARS List Award Winner 2005 Best 3rd party Remedy Application See the <http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf> ESS Concepts Guide tel +44 1494 468980 mobile +44 7710 377761 email [EMAIL PROTECTED] web http://www.westoverconsulting.co.uk <http://www.westoverconsulting.co.uk/> _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason Miller Sent: Monday, April 07, 2008 11:42 PM To: [email protected] Subject: Set an editable check box in a table field ** Hi all, I am wondering if anybody has or knows if it is possible to run a active link table loop and check a check box that is set to editable. What we have is a parent child set of forms with the children viewable in a table field on the parent form. In that table field there is a check box field that I have set to editable. What I would like to do is create a table loop that will go through and check the box in all of the child records when the Select All button is pushed. I have created a guide and AL that does a set fields to the attribute value of the check box. The only thing the AL will do is NULL the field if there is a check mark in it. I have tried using the Selection Value, the Alias Value, the ID Value for that field with no luck. I even tried using " " in my set field action hoping to emulate a press of the space bar. Just to test I added an editable character field to my set fields action and the value is entered when looping no problem. Any ideas would be appreciated. I am questioning if it is even possible to set a check box in a table field because when I click on Modify Action in my set fields it adds double quotes to any value I put in there. One workaround that I though about was to do a push field, setting the check box on the child records when clicking Select All and then refresh the table but I would prefer to just set value in the table field and then push the value with the parent is saved. Thanks, Jason ARS 7.0.1 p6 Windows 2003 SQL 2005 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
