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

or possibly adding the parents entry in the sort column to the child entry,
sort column, and formatting it in the same color as the background....

"Gary Fitzgerald" wrote:

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

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