>Too much coding done to change to SQL statements and the compound index does not work. When I use a compound index the link between the parent and child is lost.
>
>I used the tables directly since I capture data on the grid. Not sure how you would use SQL for this
In order to keep the compound index (there the first part is always the link) you need to use SET EXACT OFF setting.
If it's not broken, fix it until it is.
My Blog