You can create a saved table to table import to import records from Table A into table B to create the children. You would map [Record ID#] into the field for [Related Parent] for example. You can also create any number of additional helper fields which are not actually used on the parent, but are there to be a source for data when copied to table B.
Then set the Automation to run that saved import 7 days a week. The filters on the import will ensure that they only get hits when some conditions are true, such as the Parent is still incomplete and [2 two week reminder date] (a calculated date field) is equal to Today.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commarkshnier2@gmail.com
------------------------------