If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: multiple choices in access database

Anybody give me an idea or sample? I create a database that has different committees (maybe 20 committees). Each person in the database may have multiple commitees. And in different committe, he (she) may have different position. So in the front end, user would like to have checkbox for different committee and a textbox for the posion.
I think i need to create three tables, one is the main table has personID, another table called committee that lists all the committee with committeeID.
the third table, should be the combination of person and committee. There are CombinationID, personID and committeeID fields. Is it good idea? The problem, how can i create an entry form to add the data in person table and combination table? Do you have any sample for me? Many thanks.

Then have a sub form, in your main members form, that allows the user to add a committee and then add the position next to the selection. If you want specifically "tick Boxes" reply and I'll come up with a method for that for you.