Hi John,

How do you put all the grandparent IDs into grandchild records? I understand that every child has IDs from their parent. I'd like to put all grandparent IDs into every grandchild records. For example, the Task records should not only contain the ID from Phase but also have the IDs from Project and Company.

This way I can show all the previous Task(s) as a value list about a Company.

Bernie

Well making an unstored calc in the task that calculates the grandparent IDs is pretty easy you can just calc in the Project's Contact ID, the project being the parent, the Contact being the grand parent.

Getting indexed (as opposed to unstored) versions of this is harder because you have to account for the fact that the project's contact might change: then how to you update that project's children with the new ID?

Many developers try to avoid storing IDs more than one generation away for this reason. As for your value list, you can already show all a company's tasks as a value list just with Company -< Project -< Task, but I'm not sure what you mean by "previous" tasks.

John