Form recordset based on query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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

Steven Waugh said:
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
Click to expand...
relationship? Is there a workaround?
 
Back
Top