Skip to main content

Duplicating Records in Table B based on records in Table A


Forum|alt.badge.img+3

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.

2 replies

TheTimeSavingCo
Forum|alt.badge.img+28

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


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 4 replies
  • October 18, 2022

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


Reply