dBASE Questions and Answers - sorting middle table while keeping relationship intact. also child table while keeping relationship

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

sorting middle table while keeping relationship intact. also child table while keeping relationship

Andry

2005-12-19, 8:25 pm

Hi,
I hope I am in the right section, I am trying to re-sort a middle table (for a many to many relationship) by a field (in middletable) while still keeping the relationship (so only the related data is shown).
For example, I have a firsttable, middletable, and secondtable (all are related from firsttable to middletable to secondtable; all of this relationship is in the datamodule). Then on the form, when I try to resort the middletable using rowset.indexn
ame, it would disregard the relationship and show the whole middletable resorted.
also I am looking for the same solution for child tables in a parent to child relationship(one to many), but I think the solution for the above problem would also work on a parent to child relationship.
Any help would be appreciated.

Thanks
Andry

Sponsored Links