non-duplication of fields

Microsoft Office access 2007 (upgrade, p...
May 10, 2010 at 15:23:25
Specs: Windows Vista
I am trying to create a way in Access to update a table through different forms. The problem I am running into is duplicate entries for a student. Here is the scenario:
I have a table for math scores, the students will earn scores over four years to be aggregated at the end. I want to be able to enter the first year's scores in one form, then have another form update the same record the next year. OR if that is not possible, is there a way to combine the records?

See More: non-duplication of fields

Report •

May 11, 2010 at 05:24:48
You can enter all the records on one form or multiple if you really want. What you need is to add a field to indicate the year. Like year 1,2,3,4 or FR, SO, JR, SR.

Report •

June 29, 2010 at 15:01:03
Duplication are not allowed to make in this application, what I think so.

Apartment Software

Report •
Related Solutions

Ask Question