Thanks much! Will give it a try.

--- In IBObjects@y..., hans@h... wrote:
> TIBO_QUERY Master/Detail
>
> From my experience, this works:
>
> Assume IBO_MASTER : TIBOQuery with DS_IBO_MASTER : TDataSource
> and IBO_DETAIL : TIBOQuery
>
> set IBO_DETAIL.SQL.TEXT = 'Select * from Detail where FieldA
= :FieldB
> and
> set IBO_DETAIL.DataSource := DS_IBO_MASTER
> and
> set IBO_DETAIL.ParamCheck := True
>
> Now IBO_DETAIL will follow IBO_MASTER on
> IBO_DETAIL.FieldA = IBO_MASTER.FieldB
>
> No Error exception is raised if IBO_MASTER.FieldB doesn't exist.
>
> Don't forget unique keylinks on IBO_Master and IBO_Detail
>
> =================================================================
>
>
> slsolutions2002 wrote:
> >
> > Hello:
> >
> > I have an application I am writing with D5. The application uses
> > TIBOTables for the reports. I must use TIBOTables or TIBOQuerys
> > since my report writer does not recognize the TIB_QUERY. I need
to
> > use TIBOTables instead of TIBOuerys since I need the master/detail
> > relationship in the table and can't find this in the TIBOQuery.
My
> > problem is this: I have a few lookup fields defined for the
> > TIBOTables. They work fine (display correctly on the report etc)
> > except I need to filter out lookup records with a blank
description
> > field. IBO does not seem to handle this well. If I try to set
up a
> > filer, I get an error message that says the Field (The lookup
field)
> > does not exist. If I try to use the WHERE SQL of the table, I get
> > the same message. However, IBO allows me to define and use these
> > fields normally otherwise. If I could use the TIBQuery I could
set
> > up a join which IBO seems to handle fine, however, since I can't I
> > must use lookup fields. Is there a way around this?
> >
> > Also, I have a 2 TIBOQuerys on the form. When I select the form
to
> > make it active (at design time), I get error messages on both
querys
> > that say "Statement must have an IB_Connection assigned:
> > qrCostCategory, <No Name>." Both queries do have a connection or
at
> > least I believe they do. When I select the connection property I
see
> > my connection name in the combo box, however after selecting it
the
> > property changes to <default>. Other than the error message when
> > activating the form the queries work fine. What could the
problem be?
> >
> >
> >
______________________________________________________________________
_____
> > IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> > without the need for BDE, ODBC or any other layer.
> >
______________________________________________________________________
_____
> > http://www.ibobjects.com - your IBO community resource for Tech
Info papers,
> > keyword-searchable FAQ, community code contributions and more !
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/