Normally, I'd use a parameterized view for a situation like this because trying to use the parent/child thing can get so tricky.
In the RelationExpr property, are you entering the STR() of the FK? Since you've had to convert the integer to a string in order to combine it with the date, you need to make sure you also set the relation based on the STR() of the key.
>Thanks for the suggestion. I've created the compound index and set it as the childorder property, but the grid is still not returning any data. To create the compound index I had to convert an integer and a date field into strings in order to concatenate them. I converted the integer index in the parent table to a string as well, but this didn't help. Any other ideas?
>
>Thanks again,
>Menachem