L
La
I need a form based on the following three tables that have a many to many
relationship.
QuestionsTable:
QuestionID (Primary)
QuestionText
TransfersTable:
TransferID (Primary)
DateOfTransfer
PhysicianID
ReasonForTransfer
JunctionTable:
TransferID (Foreign from Transfers Table but Primary in Junction Table)
QID(Foreign from Questions Table but Primary in Junction Table)
ResponseToQuestion (Can be "Yes", "No", "NA", "ND")
I want a form that can display all the question text from the Questions
table with a combo box next to each question that the user can put a response
into which will be stored in the junction table. From studying Duane Hookam's
"At Your Survey", I was able to find that he uses a continuous subform with a
query that joins two tables, one with question text, and one with responses,
in the record source of the subform. When I tried this the form displays all
the questions with a response combo box (like I want it to) until I make that
form a subform of a form based on the tranfers table. The main form needs to
track transfers by TransferID, then I want the user to answer questions about
the specific transfer in the subform.
Like This---
Main Form
Transfer ID: 1
Subform
Transfer ID: 1 Question 1 Text Response: Combo Box
Transfer ID: 1 Question 2 Text Response: Combo Box
Transfer ID: 1 Question 3 Text Response: Combo Box
I can't seem to get the subform to display all the questions in a continuous
format when I link the TransferID field. Does anyone know how I can make a
form that will allow my users to enter data as shown above? I think I need to
base the form on a different query but I'm not sure how. All my attempts so
far have come up with errors. Any suggestions will be appreciated.
relationship.
QuestionsTable:
QuestionID (Primary)
QuestionText
TransfersTable:
TransferID (Primary)
DateOfTransfer
PhysicianID
ReasonForTransfer
JunctionTable:
TransferID (Foreign from Transfers Table but Primary in Junction Table)
QID(Foreign from Questions Table but Primary in Junction Table)
ResponseToQuestion (Can be "Yes", "No", "NA", "ND")
I want a form that can display all the question text from the Questions
table with a combo box next to each question that the user can put a response
into which will be stored in the junction table. From studying Duane Hookam's
"At Your Survey", I was able to find that he uses a continuous subform with a
query that joins two tables, one with question text, and one with responses,
in the record source of the subform. When I tried this the form displays all
the questions with a response combo box (like I want it to) until I make that
form a subform of a form based on the tranfers table. The main form needs to
track transfers by TransferID, then I want the user to answer questions about
the specific transfer in the subform.
Like This---
Main Form
Transfer ID: 1
Subform
Transfer ID: 1 Question 1 Text Response: Combo Box
Transfer ID: 1 Question 2 Text Response: Combo Box
Transfer ID: 1 Question 3 Text Response: Combo Box
I can't seem to get the subform to display all the questions in a continuous
format when I link the TransferID field. Does anyone know how I can make a
form that will allow my users to enter data as shown above? I think I need to
base the form on a different query but I'm not sure how. All my attempts so
far have come up with errors. Any suggestions will be appreciated.