Posted on 2007-03-20
I have 3 tables.'Companies','Subcompanies' and 'Workers'
1st one :
On afterscroll of the 1st table
with ABSQuery1 do
if ABSTable1.FieldByName('CompanyID').AsString <> '' then
SQL.Text:= 'select * from Subcompanies where CompanyID = ' +
However now I need to have workers displayed.
I want displayed only those who's CompanyID and SubcompanyID match.
That means another queery on afterscroll of the first ABSQueery1.
How is the sql supposed to look like ??