I've been searching the boards for the best way to build my form and I came across a couple of suggestions from MajP about using an unbound combobox as a main form and then linking a couple more subforms linked to that. They were only snippits and such so I'm hoping for a little more explaination or maybe even some help to wrap my brain around what I'm trying to accomplish with my datbase.
I'm trying to build a database that will allow for the inputting of each evaluation a person gets at the end of a class. I have the structure of the database that basically uses 5 tables:
tblQuestionsSeminarJoin
ID
QuestionsID
SeminarsID
tblSeminarDetails
SeminarID (linked to SeminarsID in Join table)
SeminarnameID (b/c you could have the same seminar name every year)
etc details
tblSeminartitles
SeminarTitleID (linked to SeminarNameID)
tblQuestions
QuestionID (linked to QuestionsID)
Question
Question Type
tblResponses
ResponseID
JoinID (links to ID in the join table)
etc details...
I know my names are little rookie (I'm pretty self taught, so go easy on me)but the relationships I have seem to work great as I can see 3 deep from any table aside from the titles table of course.
So what I'm trying to do, and hopefully I've laid somewhat of a good background, is build a few forms that allow for a user to go in select (or create) the seminar, see all of the questions (or select and/or add) and then come back and put in the responses. Now I realize this might take a few forms but how the heck do I get the questions to show up indivdually on the form rather than scrolling one question at a time under the seminar? I'm hitting my head against the wall on that one. I thought if I could do the unbound form with a combobox for the seminar name, link that to a questions form showing every question to that seminar, then under that question the final subform of responses.
I know its something simple and I just can't quite get it. I'm comfortable with VBA but can't even think of how to use it to what I'm a working with.
Any help is appreciated and please go easy on me . You all have my awe! This forum has been a big help!
Thanks for reading.
SDH
I'm trying to build a database that will allow for the inputting of each evaluation a person gets at the end of a class. I have the structure of the database that basically uses 5 tables:
tblQuestionsSeminarJoin
ID
QuestionsID
SeminarsID
tblSeminarDetails
SeminarID (linked to SeminarsID in Join table)
SeminarnameID (b/c you could have the same seminar name every year)
etc details
tblSeminartitles
SeminarTitleID (linked to SeminarNameID)
tblQuestions
QuestionID (linked to QuestionsID)
Question
Question Type
tblResponses
ResponseID
JoinID (links to ID in the join table)
etc details...
I know my names are little rookie (I'm pretty self taught, so go easy on me)but the relationships I have seem to work great as I can see 3 deep from any table aside from the titles table of course.
So what I'm trying to do, and hopefully I've laid somewhat of a good background, is build a few forms that allow for a user to go in select (or create) the seminar, see all of the questions (or select and/or add) and then come back and put in the responses. Now I realize this might take a few forms but how the heck do I get the questions to show up indivdually on the form rather than scrolling one question at a time under the seminar? I'm hitting my head against the wall on that one. I thought if I could do the unbound form with a combobox for the seminar name, link that to a questions form showing every question to that seminar, then under that question the final subform of responses.
I know its something simple and I just can't quite get it. I'm comfortable with VBA but can't even think of how to use it to what I'm a working with.
Any help is appreciated and please go easy on me . You all have my awe! This forum has been a big help!
Thanks for reading.
SDH