Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012
    Posts
    1

    Unanswered: Form based on two tables

    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

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    I suggest to make a MainForm on the table "People" and a Subform
    on the table "Clothes".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •