Displaying child records that have parent records in the same table.

Discussion created by hugheskc on Oct 14, 2014
Latest reply on Oct 15, 2014 by mikebeargie

I created a layout using the field picker that contains fields from a table that has parent and child records in the same table. Columns (task_id_pk, task_parent_id_fk).


Question: How do display the child records with an indentation without using a portal?




task parent

id_pk record fk Description

1 NULL (Parent record, PK=1)

1 (Child record , PK=2)

1 (Child record , PK=3)

4 NULL (Parent record, PK=4)

4 (Child record , PK=5)