Sep 30th, 2014, 7:17 PM
(Sep 30th, 2014, 6:47 AM)bhotrock Wrote: The other option is to go with a database field for each of the three options (Newsletter, Show Me Print, Show Me PDF). Then I would suggest using an Option List with Yes/No as the two Option Fields. You could assign this same Option List to each of the three database fields. Then your results will give you a Yes or No value for each of the database fields.
Regarding the email, which version of Form Tools are you running? It may be a version problem if you are on 2.2.7. Otherwise, it may be related to how your fields and Option Lists are setup. Keep in mind that if the database field isn't big enough to store all the data, then nothing will be stored. I would suggest setting your database field size larger than you think you might need until you know things are working properly.
Ok..I have 3 fields in the database. One for each option.
![[Image: 2.jpg]](http://bestchambers.com/check/2.jpg)
When I click to edit the field CEN I get this dialog box
![[Image: 3.jpg]](http://bestchambers.com/check/3.jpg)
And I get this under checkbox settings
![[Image: 4.jpg]](http://bestchambers.com/check/4.jpg)
And this when I click under edit option list
![[Image: 5.jpg]](http://bestchambers.com/check/5.jpg)
And if I click edit form fields in that box, I end up back at the beginning.
=)
When I go to option lists in the sidebar, I get this
![[Image: 6.jpg]](http://bestchambers.com/check/6.jpg)
And I'm pretty sure that's where I'm getting tangled up.
And if I click on edit the CEN line I get this
![[Image: 7.jpg]](http://bestchambers.com/check/7.jpg)
I just go around and around and around in circles.
Can you help? I'm driving myself crazzzzzzzzzzzzzy!!!