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.