In the form for adding a new record to table A we need to automatically create records in table B, one for each record in table C. Each with one foreign key field set to the new record in table A and another foreign key field set to the corresponding record in table C. (These records need to show in the form in a table list so they can be edited when filling out the form.)