>Dear Sir/madam
>
>There is a entry form of Clients in which Contacts list is also included for that particular client in a grid . Client and Contact table is linked in the data envoirement by Clncode. Everthing is working fine execpt the list of contact person showing in a grid is not alphabetical or not in correct order. If in data enviorement I Select Child table order as Clncode the display in the grid is there but any other sort order is set the display in grid is not there. Please help how to display the contact name in a grid alphbetically.

Create and use a compund index key. ie: assuming your cInCode is char :

index on cIncode+lastname+firstname tag main


* Relation
select child
set order to tag main
select Parent
set relation to cInCode into Child

Cetin