There's really nothing unusual about the SQL, they're as simple as:
Master: "SELECT * FROM CATEGORY"
Detail: "SELECT * FROM SUBCATEGORY"
Detail MasterLinks: "SUBCATEGORY.ID_CATEGORY = CATEGORY.ID_CATEGORY"
Detail MasterSource: dsCategory (DataSource pointing to the
Master Query)

The Master table only contains two columns: id_category and
description; then Detail table contains three: id_subcategory,
description and id_category (FK)
The Keylinks properties are empty in both queries... Would that be
the problem ?

Thank you
Fernando


Helen Borrie escreveu:

>
> At 01:10 AM 23/05/2007, you wrote:
> > Hello all
> > I'm getting an error when using a locate on a query. Here's the
> >situation:
> > Query1 : master table
> > Query2 : detail table
> >
> > I set the Query2.MasterSource and the Query2.MasterLink correctly
> >(pointing to Query1). The relationship is working perfectly, but the
> >locate function - only for the Query2 - returns an error, indicating
> >that the SQL of the Query2 is wrong.
> > However, if I use the MasterParamLinks instead of the MasterLink
> >(and adjusting the sql to accept the parameter), it works perfectly.
> > Is that suppose to happen ?
>
> Possibly. Show the SQL for the master set and for the detail set,
> and also the Keylinks for each set.
>
> Helen
>
>
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.467 / Virus Database: 269.7.6/813 - Release Date: 20/5/2007 07:54
>