Is it possible for more than 1 to 1 relationship?

[SJSUSTUDENT]

Hey guys, as the title says I was wondering if it is possible for more than 1-1 relationship. I am currently trying to make a proper layout for my project and I am running into some issues. I was able to successfully make these relationships, however, from the Main table datasheet view, it doesn't show me a drop down option to expand on one entry to see the related tables. I have posted an example below.

The first picture shows my relationship. The second picture I have shows that it does not expand. The third picture shows that if I were to delete one of the 1-1 relationships it does expand.

[alansidman]

Here is a link on how to create a many to many relationship

https://support.office.com/en-us/art...b-1c0b8c1f5653

[orange]

Further to Alan's suggestion, your questions table is a spreadsheet view of data - in my view.
In relational database, you might have

tblQuestion
questionID PK
questionText

separate your questions into records.

Relationships are based on the rules of your business. So get a clear description of the business you are trying to support with a database.

Here's a link to some M$oft info on database design.

[SJSUSTUDENT]

Hi guys,

Thanks for responding so quickly.

So in terms of creating many-to-many relationships. It requires that there be a junction table. What table would I have as a junction from tblPerson to tblQuestion? Then also I guess I would need a tblAnswer to contain the answers to these questions. How would I have a tblAnswer to record a short answer?

I'm going to elaborate a little bit more on my project to give you guys more information. I really do appreciate the help you guys have given me.

My sponsor has given my group the task of creating a database to keep track of people applying to her program. She is currently using three Excel files to hold all the information. One Excel sheet is considered the Master Applicant list which holds all applicants who have applied to the program whether they get in or not. It also holds answers to a simple questionnaire from her Google Form as well as items like name and address. These people are then contacted to see how serious they are about joining the program and given another form to fill out with other questions that contain a small assessment test and questions about their past employment. This is placed on another Excel sheet called Assessment. The last form is an enrollment form to verify and this will hold some necessary sensitive information about the person which is also held in the Assessment sheet. There is another file that she has that holds the placement and retention of the people who get through the program. These people are contacted regularly to see how they are doing. Overall she has about 200 columns.. give or take. It's pretty overwhelming considering she has plenty of entries already and that her data is all over the place messy. There are different Sessions to the program per year too and only some people get in.

This information may be hard to read but it's the best I can do to summarize without showing the actual Excel sheets. If you guys need more information from me let me know!

Some tables that I am currently thinking of is

tblPerson


tblGQuestion

tblGAnswer

tblAssessQuestion

tblAssessmentAnswer

tblEmploymentQuestion

tblEmploymentAnswer

[orange]

We are not going to give you a solution.
When I read your post details, the following things
seem to be the major activities and should be enough to get you started

People(Applicants) ---apply to  --Program
Program--contains --Sessions
Initial questionnaire ---completed by --Applicant
Applicant---completes --Assessment/Job History
AcceptedApplicant--- successful ---- Graduate
Graduates --followups----ApplicantHistory

Good luck.

[SJSUSTUDENT]

Thank you for the advice Orange.

This is the tables that I've come up with. I'm kind of stuck right now on how to make the questions and answers table.. I understood that my first approach made it seem like a spread sheet view and it kind of works because it allows one person to have one set of questions. But if i were to type out all the questions it would be extremely long to make queries. I have it as Q1 Q2 Q3 and etc right now. Is there a better way to go about this? I've also thought about making it as suggested of tblQuestion with questionID PK and the questions typed out there. but then I would have to make an answers table. How would i make it relate? any advice would be helpful at this point! Thanks again.

[SJSUSTUDENT]

Hi guys,

I have further improved my tables after receiving feedback that my case notes and questions were wonky. Instead, they are now going to be receiving records. Please check our my new table layout and let me know if there is anything else that I can improve on!