Write conflict

[Lifeseeker]

Hello,

This is really bugging me.

Tables are in one to many relationship.(two tables).

In query which pulls records from two tables, if I make changes to a field in query, it gives me a prompt saying there is write conflict.

Database is already split into backend and frontend. I am not sure the cause...

Any thought/comments much appreciated.

 

[boblarson]

Making changes to fields in a query which is a one-to-many can be problematic. Are you doing this directly in the query or from a form?

For a one-to-many it is best to use a main form for the "one" side and a subform for the "many" side. And you don't include the many table in the record source of the main table and you don't include the one table in the record source of the subform.

If you have to use the query, then go into design view of the query, right click in the gray area where the tables show up in the QBE grid and select PROPERTIES and change the recordset type from Dynaset to Dynaset(Inconsistent Updates).

 

[Lifeseeker]

Making changes to fields in a query which is a one-to-many can be problematic. Are you doing this directly in the query or from a form?

For a one-to-many it is best to use a main form for the "one" side and a subform for the "many" side. And you don't include the many table in the record source of the main table and you don't include the one table in the record source of the subform.

If you have to use the query, then go into design view of the query, right click in the gray area where the tables show up in the QBE grid and select PROPERTIES and change the recordset type from Dynaset to Dynaset(Inconsistent Updates).

I see. Yeah, it's problematic and I see it now. Maybe I will just get rid of feature.

Thanks alot.