How on earth do I get the syntax to work in the code to
use both DBLookupCombos text values?

I have tried many variations but obvious don't understand it.

with wwQuery1 do
    begin
    Close;
    SQL.Clear;
    SQL.Add('select MyFieldName from "table1.db" where ????
    ExecSQL;
    end;

I need this syntax to use the text from each of the lookups
as my where clause, with an AND i think.

Const
constMyQuery = 'select MyFieldName from table1 where
lookupField1=''%s'' and lookupField2=''%s''';
Begin
....
 MyQuery.SQL.Clear;
 MyQuery.SQL.Add(Format(constMyQuery,[DBLook1.Text,DbLookUp2.Text]));
 MyQuery.Open;
...
End;

NB SQL.Clear calls close automatically.

NB Format will reaplce the first %s with the first of the parameters
in the square brackets and the second %s with the second argument.

The above assumes that both the lookup values are strings, if either
or both aren't then get rid of the two single quotes on either side of
the relevant %s.

The SQL property of TQuery1 would be something like this

'SELECT myFieldName
 FROM table1
 WHERE (condition1= :c1) AND (condition2=:c2)'

next, in your code you can write somethig like this

  TQuery1.Close;
  TQuery1.Parameters[0].value:= DBLookupDialog1.text;
  TQuery1.Parameters[1].value:= DBLookupDialog2.text;
  TQuery1.Open; // (or Execute, it depensd on the result set)

in the appropiate event.

Don`t forget to define the parameter's type in the TQuery1 properties.