Solved

Automatically append records

Posted on 2013-07-01
5
288 Views
Last Modified: 2013-07-03
I have a pretty standard database with pupils studying Maths at different levels. Each level has different assessments. I would like to know how to automatically add all the assessments for a level automatically to a pupil marks table when I add a pupil to a level table.

So if pupil1 is taking Higher Maths and its has 3 assessments prelim1, prelim2, prelim3. I would like to automatically add these.

I have attached my database as I am not even sure where to start, I am guessing it has something to do with appending data but have never mastered that.

Any help appreciated as I usually just add these manually.

Regards

Tricia
Maths-for-EE.mdb
0
Comment
Question by:tmckeating
  • 3
  • 2
5 Comments
 
LVL 39

Expert Comment

by:als315
ID: 39290918
You can do it with query (Query1 in sample). To prevent duplicates be added, create complex index in your table:
index
0
 

Author Comment

by:tmckeating
ID: 39291385
Can you tell me how I could do it with a query you mention query 1 in sample but I do not see an attachment or anything....and also what the screenshot above is ...I have never used indexes.
0
 
LVL 39

Expert Comment

by:als315
ID: 39292208
Sorry, forget to upload file. Look sample.
Will be better if you change in Assmts table Alevel field to FK from table Levels
Maths-for-EE.mdb
0
 

Author Comment

by:tmckeating
ID: 39292503
I get a data type mismatch when I try and run the query.  IE will not let me attach the file but all I changed was to chnage the alevel filed in assessments to lookup the levels table..thats what you meant by a FK right?
0
 
LVL 39

Accepted Solution

by:
als315 earned 400 total points
ID: 39293140
Yes, now you should correct query. Look at new sample
Maths-for-EE.mdb
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now