Hello ,

I have a parent and Child table which has 1 to many relation like this :

Parent Table
Q1000 | xxxxx | xxxxx |

Child Table
Q1000 | B1 |
Q1000 | B2 |

When I insert or Append a new Record ‘A1’ to the Child Table
was look like this ….

Child Table
Q1000 | B1 |
Q1000 | B2 |
Q1000 | A1 |

How to change the Child Table look like this ,

Child Table
Q1000 | A1 |
Q1000 | B1 |
Q1000 | B2 |
When I set order to the index of Child Table,the relationship will be loss ...any idea ??



Thanks.