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.
That is perfectly fine, and I wish you the best in your recovery! Don't worry about this at all, and I thank you for your tips and suggestions. Get well soon my friend!
Best regards,
Terry
My illness seems to have taken a turn for the worse, and I'm finding it very difficult concentrating. I'm afraid I'm not able to deal constructively with your file, and can't see much prospect of improvement in the foreseeable future. My apologies for not being able to assist you further.
Apologies for not getting back to you sooner. My hospital stay wasn't quite as successful as hoped, so I've been rather preoccupied with juggling my medication, and have only posted here where I can send a stock reply from my library. I'll be tied up until 15 July, but should be able to look at your file after that. Good luck with your angiogram.