Search code examples
ms-accessheaderreportfooter

subform record overwriting

I'm setting up a student database,

I have a class assignment form to add the block (semester), period and class name which i can then view in a query subform at the bottom of my form.

My class assignment table is set out like this:

{ClassAssignID, StudentID, BlockID, Period, OptionID}

There are 4 classes to be chosen per block. I can add one record per block, but my problem is when i try to add a second class it just overwrites the first so it can only hold one class.

What am i doing wrong?

Solution

  • For the most part, the sql for a subform should be fairly simple, extra information can be obtained from comboboxes and link child and master fields.

    In this case, there was also a problem with indexes, as was revealed by chat. A combination of restrictive indexes and relationships prevented data from being added to the table.