Duplicating Records in Table B based on records in Table A

[Ahmad_Yassine]

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.

[TheTimeSavingCo]

Yeah script would work. Could also do this via an automation too I think, depending on how your table’s laid out

[Ahmad_Yassine]

Thanks Adam, I’m interested in the script it’s pretty much duplicating some fields in Table A and keeping the status field empty in table B. Table A has linked fields which is making it a bit harder to figure out the script.
Thanks again