subform design that will work with table structure

[Amanda Byrne]

I'm struggling with designing my subform to work well with my table structure.

I have 3 tables - People, Interest, and PeopleInterest
People table has a record for each person that interacts with our organization
Interest table has possible Interests an indivdual might have and a category
to organize the Interests
PeopleInterest contains the People ID and and their related Interest IDs.

I want to create a subform on my People form that lists all the interests in
a specific category and the user can check or select to add/remove the
interests associated with that person. From a formatting standpoint, I had
wanted to use checkboxes, but there appears to be no way to create a
continuous form that will list the interests, populate the correct
checkboxes, and still allow the add/remove via the checkbox- and the
formatting just gets ugly when you start adding the required add and delete
command buttons (because the checkbox gets its value from a calulation, and
can't be editted).

Can someone suggest the simplest, user friendly way of laying out my subform?

 

[Jeff Boyce]

Amanda

One approach you can see in action is "paired listboxes". If you open the
query wizard from the database window, you will soon be selecting items from
the left-side list and "pushing them over" into the right-side list.

In your situation, the left-side list could be all available Interests, and
the right-side list could be the Interests associated with the Person. Use
the form to get the Person (say, a combo box in the header to select a
specific Person). Then use the paired list boxes to select/deselect that
person's interests.

Regards

Jeff Boyce
Microsoft Office/Access MPV