Index child records per parents record
Hello, Is there a way to index the number of child records per parent record? What i want to accomplish is in a form display values from the same table from previously entered records. I have a parent record -- projects and a child -- cost packages. Each month the parent gets created a cost package. We need a form that displays values for this months cost package and last months cost package per project. Is there a way to index the child records per parents so i can specify to the summary field that I want a summary of the second to last created cost package? Or a summary field of (Max Index -1)? Thanks #indexing #variances #summary ------------------------------ Mackenzie Phillips ------------------------------