This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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!
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Meeting speaker
this table
meeting id
speaker
many to many relation。
so my suggestion is to consolidate relative tables to one big table and not using main subform to maintain this kind of data structure.
use unbound form if possible。
I hope your medical recovery is going well and that you are free of any complications! I may be following you that route shortly (Angiogram scheduled). Please let us know how you are doing when you are able!
Best wishes,
Terry
I appreciate the help, but please take care of yourself! I hope all goes smoothly for your hospital stay!
I've downloaded your file successfully. I'll take a look as soon as I'm able.
Hopefully this link works... Please let me know.
I hope your treatment goes smoothly and appreciate your help!
Best regards,
Machak