How can one Tie child rows to one parent row so that when A-Z sorting is
applied to a column the table is sorted but the child rows stay tied to there
parent row?

Note: The cells on the child rows are blank in the column used for sorting.

Thanks a Mil for any direction
--
Thank you,
Gary Fitzgerald

There are two ways. One is to write custom macro. The second is to add a
column with an index numbers to each row. Parents and child should be
assigned the same index number. the use the index number as a sort key.

"Gary Fitzgerald" wrote:

How can one Tie child rows to one parent row so that when A-Z sorting is
applied to a column the table is sorted but the child rows stay tied to there
parent row?

Note: The cells on the child rows are blank in the column used for sorting.

Thanks a Mil for any direction
--
Thank you,
Gary Fitzgerald

Thanks ~ Have to research Macro's.
--
Thank you,
Gary Fitzgerald




"Joel" wrote:

There are two ways. One is to write custom macro. The second is to add a
column with an index numbers to each row. Parents and child should be
assigned the same index number. the use the index number as a sort key.

"Gary Fitzgerald" wrote:

How can one Tie child rows to one parent row so that when A-Z sorting is
applied to a column the table is sorted but the child rows stay tied to there
parent row?

Note: The cells on the child rows are blank in the column used for sorting.

Thanks a Mil for any direction
--
Thank you,
Gary Fitzgerald