I'm using M/D queries with this SQL:
master:
SELECT * FROM table1 order by date_dok, ID
detail:
SELECT * FROM table2 WHERE id_table1 = :ID
and set detail TAdoQuery datasource.
When opening both queries all is OK, but when I edit detail query:
qryDetail.Edit;
I receive EDataBaseError:
'qryDetail: Field "ID" not found.'
I have not 'ID' field in table2 / query table/.
When I test with this sql:
SELECT * FROM table2 WHERE id_table1 = :ID_bla_bla
I get no error.

Is there any reason for the error?

Help please and sorry for my bad English.

Ivan

The error sounds like you have a data-aware control set to a non existent field

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

I checked all of them, then I try to "Edit" in DataModale / with no control/
and
receive error again. When I change sql /and my table/ with
WHERE ID = :ID
with the same name of the fields in master and detail table,
I receive NO error?

Ivan

"Brian Bushay TeamB" <BBus...@Nmpls.com> wrote in message
news:dj4qdt8cqto139bqdee1bupo50snte6ioq@4ax.com...