Editable Form with select query

[drunkenneo]

I have a form with split view and data it taken from different table using join query, is there any way i can add edit form data and original table data gets changed.

[June7]

A form can add/edit only one table. An exception might be possible with 1-to-1 relationship.

[drunkenneo]

A form can add/edit only one table. An exception might be possible with 1-to-1 relationship.

I have solved the issue, i made the query and selected properties of output all feilds as yes, and in form the recordset type = (dynaset(inconsistent update) which was able to solve my problem.