"CC" <se********@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Dear,
I have a form that is opened using a sql statement:
Part of the table structure:
-----------------------------------------
TbGeneral:
PK - dsr_id
TbDossierSample:
PK - dsr_sample_id
FK - sample_id
FK - dsr_id
TbCRL
PK - sample_id
----------------------------------------
On the form that is linked to TbGeneral, there is a button that
opens the form linked to TbCRL.
"Dossier" mentioned below is the primary key of TbGeneral
(Me!dsr_id)
CC,
SELECT *
FROM TbCRL
,TbDossierSample
WHERE (([TbCRL.sample_id] = [TbDossierSample].[sample_id])
AND ([TbDossierSample.dsr_id] = " & Dossier & "))"
Ok, it appears you have a cartesian product, where each row of TbCRL
is joined to every row of TbDossierSample (rows * rows), (the WHERE
is only applied after that).
This is, as far as I know, a non-updateable query.
You must specify an SQL-92 standard join (INNER, RIGHT, LEFT) on
primary key values in order for the query to be updateable (in most
cases, anyway).
Sincerely,
Chris O.