I'm trying to do my senior project and I need to be able to do 3 things:
1.) Enter data
2.) Display the data and allow a user to enter a response
3.) Compare the response to a record with a correct answer, and if it's incorrect, display a result field.
I know that I can enter data using forms. the data entry form works fine, but the data isn't linked together the way I wanted it to be. In another form meant to be used by any user I was hoping to be able to enter data into a Topic field and Question # field and be able to get a Question to appear, at which point the user provides an answer. Since the data in entered from the edit table is not linked together, I can create any combination of the added data, which in turn will display the wrong answer.
Also in the 2nd form. I'm not able to save the user's answer to the answer form I created. I think it's because they're on different tables, but I need them to be since in the data entry table, I have have the user's response yet.
The compare I think I can do using a query.
I know that it's my senior project and I'm not so bold as to ask it be done for me. I was wondering if there was any way to make this work and some information as to how.
1.) Enter data
2.) Display the data and allow a user to enter a response
3.) Compare the response to a record with a correct answer, and if it's incorrect, display a result field.
I know that I can enter data using forms. the data entry form works fine, but the data isn't linked together the way I wanted it to be. In another form meant to be used by any user I was hoping to be able to enter data into a Topic field and Question # field and be able to get a Question to appear, at which point the user provides an answer. Since the data in entered from the edit table is not linked together, I can create any combination of the added data, which in turn will display the wrong answer.
Also in the 2nd form. I'm not able to save the user's answer to the answer form I created. I think it's because they're on different tables, but I need them to be since in the data entry table, I have have the user's response yet.
The compare I think I can do using a query.
I know that it's my senior project and I'm not so bold as to ask it be done for me. I was wondering if there was any way to make this work and some information as to how.