Solved

Automatically append records

Posted on 2013-07-01
5
304 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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…
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 …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

695 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