Form recordset based on query

[Steven Waugh]

I have a form (X) that contains fields and subforms

Form (X) recordset is based on a query that has approx. 6 tables

The relationships are as follows

Table A has a 1 to 1 with Table
Table A has a 1 to 1 with Table
Table A has a 1 to 1 with Table
Table A has a 1 to many with Table
Table A has a 1 to many with Table

The problem I have is that I cannot edit the records in Table A through the form

I have read that it is not possible to edit the data on the "1" side of a relationship? Is there a workaround?

 

[Algis Kuliukas]

I Suggest building a query on the form's record source and trying to edit
columns in A. Remove tables from the query until it works and then base the
form on that query instead. Use sub-forms to display/link the data in the
tables that were removed.

Algis Kuliukas

I have a form (X) that contains fields and subforms.

Form (X) recordset is based on a query that has approx. 6 tables.

The relationships are as follows:

Table A has a 1 to 1 with Table B
Table A has a 1 to 1 with Table C
Table A has a 1 to 1 with Table D
Table A has a 1 to many with Table E
Table A has a 1 to many with Table F

The problem I have is that I cannot edit the records in Table A through the form.

I have read that it is not possible to edit the data on the "1" side of a

relationship? Is there a workaround?

 

[Steven Waugh]

Sorry Algis

Not speaking your language? I don't understand what you are saying?