Form based on two tables

[maciej_wroclaw]

Hello,

I have a feeling that my problem is very easy to solve but for some reason I am not able to figure it out for hours..
In order to explain you my situation let's assume that I have two simple tables. In the first one, called "People" I have few columns which are describes people. On the second table called "Clothes" I have names of clothes that those people are wearing, eg. treasures, t-shirt etc.

I would like to have a form which will show all columns from table People and group of checkboxes (as many as I have rows in table 'Clothes'). I would like to 'tick' what kind of clothes these people are wearing.

Could you please guide me how can I accomplish goal described above? I would really appreciate any help which you may provide. If anything is unclear, please let me know - I will try to describe the situation in other words.



Thank you in advance,
Maciej

[June7]

If you want to save the checked selections for each person, need a another table - a junction table - because the relationship is many-to-many. Then use form/subform arrangement. Main form bound to People, subform bound to junction table (PeopleClothes). The Clothes table would be RowSource for a combobox in the subform. Each record in the subform would be an item of clothing selected from combobox.