Can't edit query data with more than one table source

[smercer]

Hi all

I am trying to make a query that has two table sources, first table (one field) to count the related records to the main table.

The problem with this query is that I can not edit any records that the query shows.

Does any one have a solution?

Thanks in advance

 

[rbrule]

You can't update a record directly from a query containing two tables. You have to create a form from the query and change the "record set type" property to Dynaset (Inconsistent Updates). The "record set type" property is under the form properties. That should solve your problem.

rbrule

 

[smercer]

You can't update a record directly from a query containing two tables. You have to create a form from the query and change the "record set type" property to Dynaset (Inconsistent Updates). The "record set type" property is under the form properties. That should solve your problem.

rbrule

Thanks rbrule

I fixed my problem.

Thanks