I have a datagrid with data coming from 2 tables which are joined on 1 field. When a new record is inserted into the grid, the datagrid is trying to insert 1 record into each table in the query. I only want the main table to be updated. The same kind of thing happens when a record is deleted. The data is deleted from both tables rather than just the main table. Is there a way to make sure only the data from the main table is affected?