I worked out the second part of my question reference showing a tick in the check box if 1 is written to the db. (1 = yes 0 = No)
1. Clicked on the checkbox and in the properties panel, click Dynamic.
2. Click on the "Check if" Lighting Bolt and choose the desired check box from the Recordset.
3. In the "Equal to" box enter 1 and click ok