Mellya (mellyjc) wrote in databases,
Mellya
mellyjc
databases

  • Music:

Many-to-many in Access?

I'm new to Access and would like a little reassurance I'm on the right path...


My form will have the date, along with a list of items from a table. I want basically a list of checkboxes for each of these items. I want to track over time the frequency each of these items were checked.

Am I right to think this is a many to many situation..as the date is tied to numerous items for checking, and each item for checking can be tied to any number of dates?

There is all of one paragraph about many-to-many setups in my book, and I'm not sure their illustration works the same way I'm thinking. If anyone can provide some assistance on a many to many setup, or at least setting me on the right path if I'm not, I'd greatly appreciate it!
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your IP address will be recorded 

  • 6 comments