Louis
Make a single view with the child table being the main table and include the MASTER table in the view doing a right sided join. This will create a view with the children records and the master ID as an additional field

Jon

>Hi all,
>
>I've 2 vues:
> VUE_MASTER(MST_ID, MST_CHD_ID)
> VUE_CHILD(CHD_ID, CHD_DESCRIPTION)
>
>I have a grid with 2 columns:
> COLUMN1.CONTROLSOURCE = "VUE_MASTER.MST_ID"
> COLUMN2.CONTROLSOURCE = "VUE_CHILD.CHD_DESCRIPTION"
>
>INDEX ON VUE_CHILD.CHD_ID
>RELATION with VUE_MASTER MST_CHD_ID.
>
>CoLumn1.HEADER1.CLICK() ==> INDEX ON VUE_MASTER.MST_ID
>COLUMN2.HEADER1.CLICK() ==> (I'd like to order my grid by CHD_DESCRIPTION)
>
>HOW can I order my grid my a field located in my child table?
>
>Thanks a lot