Subdatasheet Sorting

[bradsr0138]

I am having on heck of a time trying to sort a subdatasheet in my table. I have a table that has tiered subdatasheets as follows:

• Table 1
  • Table 2
    • Table 3
      • Table 4

For some reason when I open table one and get to the record I need in Table 3, Table 4 is sort any which way it feels like and no matter how many times I changed the sort order, it still keeps messing up when I go to a different record in Table 3. I hope this is clear enough for someone to understand and maybe help with.

 

[Galaxiom]

Abandon subdatasheets. The users should never see the tables anyway.

Althrough subdatasheets can be useful during development they have very limited capabilities and are not suitable for inclusion in a user interface.

Use forms with subforms.