I'm just getting back into Access after a 8yr stint hiding away in Excel.
I'm using Access 2010 using a standard DB, (no SQL server).
I am trying to create a new record in the Previous School table based on an existing value of Student table.
Every student has an ID number, and every new...