Help on Query

[Alain]

Hi to all,

I have a problem understanding something
I need to build a query based on 3 table, this should be simple but I am
unable to update the recordset on my form based on this query:

SELECT tblProperty.IdProperty, tblProperty.IdType,
tblProperty.IdBusinessGroup, tblPropertyCostsTaxes.LandCosts,
tblPropertyCostsTaxes.LandMunAssess,tblCompany.CieName,
tblCompany.CieAddress
FROM (tblProperty INNER JOIN tblCompany ON tblProperty.IdProperty =
tblCompany.IdProperty) INNER JOIN tblPropertyCostsTaxes ON
tblProperty.IdProperty = tblPropertyCostsTaxes.IdProperty
WHERE (((tblProperty.InActive)=No));
I would like to know what is causing my problem, also I notice that whatever
relationship I create I always end up with a one-to-many between my
tblProperty and my tblPropertyCostsTaxes by Access

Can anyone help me out on this one

Thanks

Alain

 

[Alain]

After some research I finally found the solution,
for those who are having the same situation you need to set the forms
recordset type to Dynaset (Inconsistent Updates)