I am reproducing a report originally designed to be manually completed in Word. The client wants it be an 'exact' replication. On the original form I have a table with three columns - the item to be considered, a 'yes it applies' column (checkbox), and 'no, it doesn't apply' column (checkbox). The user check either yes or no. (see below)
In my database table design I have simply set the field for each of the items to be considered to yes/no. However, this only gives me a single checkbox - marked for yes, unmarked for no.
How can I use this field to re-create the separate yes/no checkboxes on my report?
Current Word format:
Issue Applies
Issue abc [] yes [x] no
Issue xyz [x] yes [] no
Issue 123 [] yes [x] no
In my database table design I have simply set the field for each of the items to be considered to yes/no. However, this only gives me a single checkbox - marked for yes, unmarked for no.
How can I use this field to re-create the separate yes/no checkboxes on my report?
Current Word format:
Issue Applies
Issue abc [] yes [x] no
Issue xyz [x] yes [] no
Issue 123 [] yes [x] no