I have a form which must update a parent table as well as several child tables. I want to use a local view for this but I'm not sure how to add new records to a child table without affecting the parent table or the other child tables.

Can anyone help me with this?

Thanks in advance.

Bill Richardson
Computerized Sport Systems Group
Faculty of Kinesiology
The University of Calgary
Internet: richards@acs.ucalgary.ca