Hi All

I have two queries linked in a master-detail relationship.  They are linked
via a field called "code" which
is set as a parameter in the detail query.  I need to add extra parameters
to the detail query which I will
manually set.  Is this possible?  I get an error that the field(parameter
name) does not exist in the master query.

Thanks

Godfrey,

<< I have two queries linked in a master-detail relationship.  They are
linked via a field called "code" which is set as a parameter in the detail
query.  I need to add extra parameters to the detail query which I will
manually set.  Is this possible?  I get an error that the field(parameter
name) does not exist in the master query. >>

You need to assign data types/values to the "manual" parameters prior to
opening the query, otherwise the TDBISAMQuery component assumes that they
need to be assigned automatically using the master datasource's fields.

--
Tim Young
Elevate Software
www.elevatesoft.com