Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Automatically append records

Posted on 2013-07-01
5
Medium Priority
?
310 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
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 …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

610 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