Heres a little poblem that I have encountered. I have two grids on a form, the first one holds names and addresses of parents, the second grid holds names and DOB's of their children. Now in order for the relationship between the grids to work I have to have the child table ordered on a particular index. So far, so groovy.

Now what I want to do is to add the ability for the user to click on various grid headers to re-order the grid display based on the column that the header sits on. To do this, I would think that I would have to use another index tag on the child table but this would break the relationship and nothing is diplayed in the grid.

It doesnt sound too hard a thing to do, but I've been staring at the problem so long now that I cant see the wood for the trees.

Any ideas?


Ashley Cottle
AssureSoft Ltd
AshleyC@cosworth.infotrade.co.uk