OK, sure.
Make a helper table called Automation Focus. Add 1 record.
Make a field called [Record ID# of Focus Parent]. Make a field called [# of children required].
Make a new table called with say 100 records called Children Source in it and number them from 1 to 100. You can use the Record ID# for this purpose as long as you create the records and then stop anyone from deleting records, even the Admin. You can import from excel to create the records and populate a dummy fields to be deleted.
Make a relationship between Automation Focus and the Children Source to lookup the
Make a lookup from the Automation Focus for [Record ID# of Focus Parent] and [# of children required].
Make a saved table to table import to map from Children Source to the child table but limit where sequence # is less than or equal to the # children required.
Lastly make a formula URL button to do three steps.
Populate Automation focus
Run the Import
Redisplay the record.
If you want the records to automatically populate the children whe the parent is created, then this can be done in an Automation.
ie populate the Automaton focus
Run the import.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com[email protected]------------------------------
