This should be a simple question, but for some reason I can't find a straightforward answer online.
I have a database to keep up with academic information for students and, as you can imagine, this involves many many many fields. More than Access will support in a table.
I started out with a table that used the student ID as the first field and PK and then included more than the 255 fields allowed by Access. I split the table into a main table and 4 subtables, each using the student ID as the PK and established a 1 to 1 relationship between the main table and each of the subtables with referential integrity enforced. Obviously, my preference would be to keep this as one big table, but Access just won't let it happen.
I assumed that when I added a NEW student to the primary table, a matching new record would be added to each of the subtables. Apparently, that assumption is wrong. Do I actually have to manually add each record to EACH of the 4 subtables? There seems to be no other way of doing this, but having to remember 4 additional steps each time I get a new student is insanely annoying (and easy to forget)!
Any suggestions would be appreciated.