Solved

Automatically append records

Posted on 2013-07-01
5
303 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 400 total points
ID: 39293140
Yes, now you should correct query. Look at new sample
Maths-for-EE.mdb
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Suggested Solutions

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

738 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