Hoping for some advice and/or direction. Trying to build what I think should be a relatively easy application in Access. It is essentially a questionnaire for evaluating file documentation.
I have the database structure defined to where I think it should be but don't have the depth to figure out how to insert, update and delete the table data using forms.
Here is the database structure:
Here is what I envision the entry form looking like:
The data from the fields in the top, purple circle would be written to tblReviewData. This is simple enough as the form and necessary buttons can be added through standard wizard functionality.
The data from the fields in the bottom, red circle would be written to tblReviewResponses with the data relating back to tblReviewData joined on ReviewDataID. tbleReviewResponses is essentially the collection of questions (QuestionIDs) from tblQuestions that have been displayed to the user and have received a response (ResponseValID) from tblResponseVal that then relate back to the tblReviewData on ReviewDataID. Ideally the questions would be conditionally displayed based on the 'ContractAmount' value (I don't think this will be that difficult).
I am having fundamental issues in determining how to add records to tblReviewResponses.
Does anyone have any examples of this type of thing in a sample database? Any advice or resources that might help me out would be greatly appreciated.
Thanks!