I need to automate duplicating records in Table B based on records in Table A maybe a script? The idea is a school database, I need to pre-generate attendance records with a date and have teachers simply click on "Present’ or ‘Absent’ field.