DrChocolate
New member
- Local time
- Today, 07:41
- Joined
- Feb 21, 2012
- Messages
- 7
Greetings: Here's the background: Using Access 2010, my overall project is to construct a database keeping track of support group data. Each group (e.g., Alcoholics Anonymous) is assigned to one or more categories (e.g., Addiction-Drugs, Addiction-Alcohol). The website will hopefully used MySQL or something similar to take advantage of the Access table structure.
Here's the relevant table structure: It's many to many (groups and categories) here, so I've got one table for overall group data, one listing categories, and a junction in between using a GroupID and a CategoryID to carry me through.
Now the question: When I'm entering a new group, I allow a choice of one or more categories. I'd like to display them in multiple columns across the screen where each chosen category "lights up" or somehow shows that it is "on" (or chosen). A left click on a category name would toggle "chosen" and "not chosen". (By the way, a right click might hopefully display a list of tags associated with that category.) The display design will be important so that I can look at the list and see very quickly and clearly what's on and what's off as I interview the group representative on the phone.
How do I construct a form that gets as close as possible to my desires? Thank you.
Here's the relevant table structure: It's many to many (groups and categories) here, so I've got one table for overall group data, one listing categories, and a junction in between using a GroupID and a CategoryID to carry me through.
Now the question: When I'm entering a new group, I allow a choice of one or more categories. I'd like to display them in multiple columns across the screen where each chosen category "lights up" or somehow shows that it is "on" (or chosen). A left click on a category name would toggle "chosen" and "not chosen". (By the way, a right click might hopefully display a list of tags associated with that category.) The display design will be important so that I can look at the list and see very quickly and clearly what's on and what's off as I interview the group representative on the phone.
How do I construct a form that gets as close as possible to my desires? Thank you.
Last edited:
