ok the criteria with hath i have the problem looks like this


SELECT DISTINCT table1.col1,...,table1.columnN,......TableM. Column X
FROM Tables1, Table M
INNER JOIN Table1
ON (table1.col1 = tableN.colZ) , Tablex
WHERE (table1.col1 = tableN.colZ)
AND (table1.col1 LIKE '............')

in this section '........' i have to introduce the next statment editbox text or other component externaly introduced datavalue wich is al integer value asstring

yess it is exactly whath i want to use an earlier or exactly the last data introduced in the table to wiew all the modification iff necesary, and to bee able to list somme modified data if it is needed.
thanks bekause sommebody sad to mee thath i have to write somme special procedure to do this thing.

yess the ideea is good, but it gives me back somme empty cells and i'm sure thath i have data in the tables

the code is the folowing:
"SELECT DISTINCT Contractdetailat.NRCONTRACT, Contractdetailat.DINDATA,
Contractdetailat.PINALADATA, Contractdetailat.PUNCTDELUC,
Contractdetailat.COMPONENTE, Contractdetailat.PRETUNITAR,
Contractdetailat.NRBUC, Contractdetailat.PRETTOTAL,
Firma.DENUMIREFI, Firma.NRREGCOM, Firma.CODFISCAL,
Firma.SEDIULSOCI, Firma.JUDETUL, Firma.CODIBAN,
Firma.BANCA, Firma.PUNCTDELUC, Firma.NRCONTRACT,
Delegati.NUMELEDELE, Delegati.BI_CI_, Delegati.SERIA,
Delegati.ELIBERATPO, Delegati.MIJLOCTRAN,
Delegati.NRMASINA, Delegati.DATAEXPED
FROM "D:\ISTI\28.11.2006\contractdetailat.dbf" Contractdetailat
INNER JOIN "D:\ISTI\28.11.2006\firma.dbf" Firma
ON (Contractdetailat.NRCONTRACT = Firma.NRCONTRACT) , "D:\ISTI\28.11.2006\delegati.dbf" Delegati
WHERE (Contractdetailat.NRCONTRACT = Firma.NRCONTRACT)
AND (Contractdetailat.NRCONTRACT like'?"&intrari.nrcontract.text&"*')"
now the rezult soud be
at nrconract i have 25 contracts with the afferent next rows and i don't need all of it listed in the same sheet in one sheet i need listig of only one contract that is tha ideea.
thanks.
by the way the program is one man creation i'm vorking solo and it is werry hard to work solo

the return rezult is zipp !!!!!
it is a blank datatable
I'm sure there is somme data on it because it when i select all it can be displayd in a data gird