>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
i had this problem and wound up using the views for viewing, but opening each table on its own for adding data.