two right join suddenly changes to not updateable?

[Ginola]

Hi,

I have a two right join as following. The query is working probably
and can be modified previously. However, it can't update recently and
not sure why? a record has corrupted previously and I use compact to
fix the problem. Does anyone know what's the problem is ?

SELECT QC.QCNo, QC.SupplierName
FROM Brand RIGHT JOIN (Product RIGHT JOIN QC ON Product.ArticleNo =
QC.ArticleNo) ON Brand.BrandName = Product.RBrandName
ORDER BY QC.QCNo;


thanks

 

[david epsom dot com dot au]

When you repaired, you may have lost an index. Check that
all indexes are still correct. If you have a defined
relationship, remove the relationship, compact, then
put the relationship back.

(david)

 

[Ginola]

Hi David,

thanks you for your help, the primary key has gone after compact...
it works fine after set it up again.

Ivan