Hi.

In IB_query i have this kind of sql statement.

select m.*,
(select "Name" from "customer" d where d."Cust ID" = m."customerid")
as "Name"
from "customerinvoicerequirement" m

And Iam not able to add the "Name" field into the orderinglinks. Is
there a way to solve this thing? I have try this kind of sql instead.

select m.*, d."Name"
from "customerinvoicerequirement" m left join "customer" d on d."Cust
ID" = d."customerid"

With this kind of sql I have add the "Name" field into the ordering
links. But this statement doesn't work well when setting up a
ib_lookupcombobox.



regards,
james