At 09:35 PM 29/11/2004 +1100, you wrote:

> > Custom XxxxxSQL properties won't be needed. The
> > Master-detail relationship will take care of the first
> > segment of the key, the Lookup relationship will take care of
> > the second. All that's needed is to pop a TIB_LookupCombo
> > into the detail grid.
> >
>
>Helen, thank you once more for the help. I will have to get you something.
>
>It works :-))))))))))
>
>I had to provide EditSQL and DeleteSQL, otherwise it was not allowing
>updates or deletions.

then I suspect you forgot to set RequestLive true.

>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.