I'm creating a database to track student data and create report cards. Report cards have their own table and access student data through a "Students" table using student ID number. I have a value list containing all student ID numbers. I would like to generate a record in the report cards table for each student ID in the value list, but I cannot figure out how to script it or if it is possible to do so.
Is it possible to create a new record for each value in a list and if so, how would I go about doing that?
Any help/hints are appreciated.