> then I suspect you forgot to set RequestLive true.
>

Well True. My mistake as always, I am not using RequestLive. Thus
RequestLive=false

>
> >If I was to change the detail query to:
> >
> >SELECT ACM_DOUBLEKNOCKITEMS.DNI_DN_ID
> > , ACM_DOUBLEKNOCKITEMS.DNI_AC_ID
> > , ALARMCODES.AC_DESCRIPTION AS ACDESCRIPTION FROM
> >ACM_DOUBLEKNOCKITEMS INNER JOIN ALARMCODES ON
> >ALARMCODES.AC_ID=ACM_DOUBLEKNOCKITEMS.DNI_AC_ID
> >
> >Would it be correct from your point of view, as at a later
> stage, the
> >set of ALARMCODES.AC_ID will be restricted to match a
> particular value.
>
> Sorry, I don't understand how that's different to what you
> already have.
>
> H.
>

I obviously have an incorrect understanding of sub queries. Thus, my attempt
to convert it to an INNER JOIN.

Once more thank you.

Hope that Melbourne is cooler than Sydney, as the Aircon in the building
died on Friday, and we are still waiting for the repairs person.

danieL.