Tabular data entry

[Aviram]

Hi all,



I'm trying to figure out a way for data entry to this kind of DB:
Table 1: Children (Id, name)
Table 2: Subjects (Id, name)
Table 3: Grades (Id, Child-FK, Subject-FK, grade, date)

Each child may (or may not) have a grade in each subject (think of subjects of classes in school).
Child list and Subject list may be changed after development is finished.
I'd like to create a form that resembles a pivot-table and enables data entry. Such as:

Date: ________

Child Name	Algebra	History	Geography	Computers
Joe	75		87	80
Jane	84	79		100
Jack	77	77	77
Jill	66	55	77	3

Is this even possible? If so, how?
I'm not affraid of writing code and generating the form on the fly, but the basic problem I encountered was how to design my data source SQL.

Would love some help here,
Aviram

[June7]

Student database is fairly common topic. Here is recent: https://www.accessforums.net/access/...sue-46450.html

[Aviram]

Thanks, June7.
The problem I presented is not specific for students. It is easily explained with them. One could think of Animals and characteristics (lion, zebra, horse vs. height, weight, number of toes), diseases vs. treatments and so on.
The main problem is that I need to create a sort of cross-table that enables data entry. Couldn't find a solution for that in previous post (here or elsewhere...).

Aviram

[June7]

Cannot do that with a bound form and normalized database.

Would have to be unbound form and lots of VBA code to display data and to save data.

Not something I would enjoy doing.