How to Setup a Survey Database with Option Boxes

<< Click to Display Table of Contents >>

Navigation:  The Toolbox >

How to Setup a Survey Database with Option Boxes

By Garry Robinson

 

Here are some screen shots that I captured whilst working out how to setup a database for collection of a survey. The technical solution here is how to setup an option box data entry system to match the original survey. Click on first picture to expand

surv1_zoom30 Original Survey

surv2 Questions table

surv3 Questions table

surv4How to use the lookup wizard for the question table

surv5

 

surv6

surv7

surv8

surv9

Options Box Time

surv10
Copy the data in the Questions lookup table before adding the Option box

surv11 Now use the Options box

 

surv12

surv13

surv14

surv15

surv16

surv17Here is the UI

Copying Option Boxes for Other Questions

surv18

surv19

Thats it :)

Garry Robinson