ADDING LOOKUP PROGRAMMATICALLY

[hbez]

I have an ADOQuery qry1 which gets its ConnectionString programmatically. I need to add a Lookup field but, when I double-click the query, Delphi (7) complains there is no ConnectionString. So I need to code in the new field. I get as far as - I hope that's correct -

<code>
qry1.FieldList.Add('MyNewField');
with qryElect.FieldByName('MyNewField') do
begin
DataSet := qry1;
KeyFields := 'Affiliation'; ...
</code>

but then get stuck with defining the ListSource, ListField and DataField.

Much appreciate any help here with my edification.
Hannes

 

[whosrdaddy]

don't use lookup on ADOQuery objects.
change your query instead.

/Daddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[hbez]

Many thkx for the reply, however, I use qry1 to populate a dbgrid from table1, I then need an extra (lookup) field to qry1 that will get its data from Table2 and display it as a dropdown box in a cell of the dbgrid. Hope my explanation makes sense?
Hannes