Hi all,

I am trying to set a YES NO checkbox field to either YES or NO in a script but the programming tools will not let me - it states that the table cannot be found. Any ideas?

Thanks

Edited September 22, 200817 yr by Guest

You are most likely trying to set the field on a table occurrence that is not related to the layout that your script is currently on. But I am just guessing here.

Please post your script.

Hi John,

New Record/Request

Set Field[Learners::Course Completed;)

The field is a text field completed by a YES NO checkbox. However, I cannot set the field to either YES or NO in the script tools when I specify what to set it to. After the Course Completed; XXX should be what I want to set the field to, I am assuming.

Thanks

I am not following what you are trying to do here.

You can set a field as part of a script with a specific value.

New Record / Request

Set Field [ Learners::Course Completed; "NO" ]

or you can use an auto-enter DATA value of "NO"

Then each time a new record is created it will default with "NO" which is what I believe you are trying to achieve...

A ha. Nice one John. I was failing to put my NO in "". I thought seeing as the script tool does SO MUCH for me it would do that as well. LOL

many thanks

Rich