I am trying to create what I thought would be a simple data entry form, but I am obviously missing something here. I am trying to create a database of articles about club meetings. For each article I have variables:
Article ID
Source
Title
Author
Related meeting
For meetings I have:
Meeting Date
Place
Speaker M
Source Article
Each meeting could have multiple speakers and speakers could have multiple topics, so I have the following two tables:
Speaker
Meeting Attended
Topic
Suptopic
Speaker T
The relationships are as follows:
An article could relate to a single meeting, or no meeting. One to one/none (Article ID - Source Article)
Each meeting could have multiple articles. One to Many (Source Article - Article ID)
Each meeting could have multiple speakers, and speakers could talk at multiple meetings. Many to many (Speaker M - Speaker)
Each speaker could have multiple topics. One to many (Speaker - Speaker T)
However, when I try to create forms with subforms, it is as if all relationships become 1:1 for data entry. I can not seem to find how to put multiple speakers in a meeting or multiple topics for a speaker. I know I am missing something simple here but I can not find it in the online videos. Please help!