>Should I wrap the whole thing into one transaction? Or do I have each record added as entered? I like the PageFrame idea.
Probably down to specific requirements. There are different options here. As for transactions, I would prefer to use single transactions but there may be a requirement for the parent record to be added immediately and possibly the first child record? Another option is to use cursors to hold the data until you finish and then add them.
This is similar to the data entry system I used many years ago where you have different levels. The first was normally a summary (number of records to follow) which could be validated when finished entering records. Each set of data was in a separate file and could be updated to the main tables at the end of each entry run - probably not what you want but may offer some insight.