Data assist Checkbox

I would like to replace the following code with a checkbox.
I have tried but cannot seem to get it to update.
In mysql I am using a tinyint with a default of 0

<div class="lineGroup"> <label for="Class" class="sublabel" > class:</label>
<div class="errorGroup">
<span>
<input id="Class" name="Class" type="text" value="<?php echo((isset($_GET["invalid"])?ValidatedField("boatsresults","Class"):"".$row_WADAboatsq["Class"]."")); ?>" class="formTextfield_Medium" tabindex="36">
</span>
</div>
</div>
Any ideas please?
Many thanks
john

what is the value that will be stored if the checkbox is checked?

delete the text box from the page.

then add a checkbox and name it "Class"

Set the value to be what should be stored in the database when the checkbox is checked.

in the property inspector, click the dynamic button, and set the Check if option to:

<?php echo((isset($_GET["invalid"])?ValidatedField("boatsresults","Class"):"".$row_W ADAboatsq["Class"]."")); ?>

for the Equal to option, enter the same thing you entered for the value.

Thanks Jason

I think I had a problem with the check box field name "Class"

I have now changed the field name and I am able to create the checkbox within the Data Assist wizard.

Regards
John