Double Check Boxes per value

[Answers]

Not sure if this is possible, I'd like to have two checkboxes for each value. I've attached an example in PDF. The values are just used for display and print purposes. I know I could work around the issue by creating two value lists that are checkboxes, put them next to each other and on the one checkbox item only display the actual checkbox not the text.

I hope this makes sense!

Thanks in advance.

Caroline

DatabaseColorblockex.pdf

[comment]

What does the actual data look like?

[Answers]

What does the actual data look like?

It is basically a dress catalog, There is a list of maybe 100 colors. Each item only comes in certain colors and it varies according to US or Canada. So the List would have 2 checkboxes with one color, check box #1 refers to the US, checkbox #2 refers to Canada.

Box 1 Box 2 Black

Box 1 Box 2 Blue

So perhaps Canada has only that style in Blue, So box #2 next to blue would be checked. But the US has both colors so Box1 would be checked next to both Black & Blue.

Thanks

[Answers]

I know I could work around the issue by creating two value lists that are checkboxes, put them next to each other and on the one checkbox item only display the actual checkbox not the text.

I just made additional fields and displayed the checkboxes next to each other (one showing the text, one not). It works fine... just thought there might be another way.

Thanks

[comment]

There are other ways - but if you need this only for display/printing, then two fields (using the SAME value list) with the left field narrowed to show only the checkboxes would be the easiest one, IMHO.