?
Solved

Automatically append records

Posted on 2013-07-01
5
Medium Priority
?
306 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 40

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 40

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 40

Accepted Solution

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

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

800 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