General information
Category:
Forms & Form designer
Title:
Grid secondary sorting
I have a main table and a child table, all connected with appropriate primary (parent) and foreign (child) key: "indexes". The form has both tables displayed in its own grid. Move the pointer in the parent and all the children repopulate, according. It works great.
I don't display any of the pk/fk on the grids.
Now I would like everything to stay connected but I want the child table displayed in descending order on one of the date fields (most current on top). The child table has an index tag [INDEX on dtos(sentdate) TAG sentdate DESCENDING] and I would like it to sort the display of the child grid without disrupting the already established pk/fk connection.
This doesn't sound all that complex, but changing the controling index of the child table looses the pk/fk connection. Is there a way to keep the pk/fk link but display the child grid in a different order.
Dallas
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only