Mellya (mellyjc) wrote in ms_access,
Mellya
mellyjc
ms_access

  • Mood:

Many to Many Relationships

Hi,

Sad to say, I'm brand new to Access. I've got Access 2000, and a "Comprehensive Enhanced" book for Access 97.

So far things are sort of making sense and I'm feeling it out..but I feel like I'm at a mental block for how to implement further.

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 and I'm not sure their illustration works the same way I'm thinking. I feel fuzzy on this matter. If someone can let me know if I'm at least on the right track for what I'm trying to do, or provide some assistance on setting up a many-to-many relationship, I would be much obliged!

Thanks!
  • Post a new comment

    Error

    default userpic
  • 1 comment