Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Need help with Microsoft Access?

Ok, my problem is this. I want tot create two tables, where the relationship between the tables is the primary key on one table, referencing multiple entries on the other. An example is, I have a table of attributes, and a table of people. The people can have multiple attributes. In my attribute table they have a unique (PK) number and a description. In my paople table I want to list the attributes with yes no check boxes, and then through cross reference create a report and form with attribute descriptions. Can anyone help?

2 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    I would suggest using a third mapping table which has a many - many structure . It will accept the ppl id and the attribute id and link the two together.

    Using simple joins you can then create the report and form

  • Anonymous
    1 decade ago

    i would get all that data, throw it into an excell DATABASE ... then have a smoke cos it was too easy.

    By the way, thanks for all your help, i'm super proud of our DATABASE.

    love you!!

Still have questions? Get your answers by asking now.