473,289 Members | 2,155 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

Which Method? Storing Multiple Instances, Saving, Viewing

Summary of My Project
Database to store names and attempts at completing different tests.
Person can attempt any test, several times.
Each time they take any test, needs to store: test name, date, and results.
There are 3 different tests. All tests are basic yes or no questions (so, "yes/no" or just checkboxes can be used) No multiple choice answers. Just yes or no.

My Tables
Table1 (PersonID, Name, Date, TestID) * main table
Table2 (TestID, TestName) * stores all main test names
Table3 (QuestionID, TestID, QuestionText) * stores all questions related to a specific test

Person enters name, enters a date, and selects a test. On update/change of test field, it loads the yes/no questions related to test.

I am not understanding the methodology behind next step.
- person can put yes/no values or check marks in box for results. Save test.
- they can attempt the test again at any time. So, if they took the test 5 times, saves the results of each test as a record.

I have tried creating Table4 (ResultID, PersonID, TestID, QuestionsID, and a field called Results (Yes/No). But, questions called to populate a page, with check boxes, does not work.

Do I select all questions related to a test from the table, and then update records in Table4?

I appreciate any direction.
Oct 20 '21 #1
0 4530

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Vlad | last post by:
Is there any way to install multiple instances of the same windows service designed with VS.NET 2003? I tried copying the binaries into a separate folder and then copying registry entries for the...
11
by: Mike | last post by:
Looking to find any information on how to properly configure multiple instances of DB2. This is on Win2k db2 ver 7.2. I am basically looking for information on how the multiple instance settings...
4
by: Yasaswi Pulavarti | last post by:
I have a Aix 5.2 server with DB2 UDB 8.1 I created three different instances using the db2setup utility three times. The default instance is db2inst1. When I su - db2inst2 and su - db2inst3 and...
2
by: (Pete Cresswell) | last post by:
I have a situation where a bunch of statistics are being presented based on a mutual fund and a benchmark fund's monthly and quarterly returns for a given period (like 10 years....) The hitch...
5
by: David W. Fenton | last post by:
I'm blanking out on this one. In an old applicaiton, I am implementing a new feature to allow the user to open multiple instances of a main form. I've got that working, using the code for this...
11
by: Clark Stevens | last post by:
I just finished a WinForms app in VB.NET. I want to allow the user to be able to run multiple instances of the program like you can with Notepad and Wordpad. The way it is now, once I run the...
0
by: Sunil Pandita | last post by:
Hi all, I have created a windows service that is working well. Now i want to create the multiple instances of this service on the same box. How could it be possible?. One way that I thought...
6
by: Bugs | last post by:
Does anyone have any recommendations on the best way to create multiple instances of the same class when the final number of instances is unknown? For example, I have a class and based on some...
5
by: =?Utf-8?B?YjF1Y2VyZWU=?= | last post by:
hi, i need help building multiple instances of an enumerator and naming each one filter1, filter2, filterN depending on how many the user requires, here is the code i have so far public enum...
4
by: nottarealaddress | last post by:
I'm trying to get my feet wet in VB2005 (our new standard at work after officially stopping new development in VB6 about a month ago). I'm working with a simple sql 2005 table of 50 entries, one...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.