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

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.

Thank you very very very much

danieL.


____________________________
Comvision Pty. Ltd.

www.comvision.net.au