Well yes for this
When additional people need to be added for future check ins, will I have to have them added to the Membership table
I presume that in your credit app a member cannot do a checking unless they already exist as a member.
as for this
Can automation be setup to remove duplicate records (if any) once per day?
Are you asking to have a duplicate check in records deleted if so yes an automation can remove records which are duplicated where the same member has more than 1 check in for a member meeting record. The automation would retain all these a check in which had the Minimum Record ID for the check-ins related to the member meetings table and delete the rest.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------