none
Showing multiple instances of child record using data model RRS feed

  • Question

  • We are using a data model as the basis for reports, and I need to know how to get the data out in a certain format. The data in question involves two tables -we will call them "Parent" and "Child". These have the following fields:

    Parent.ID
    Parent.Name

    Child.ID
    Child.ParentID
    Child.PriorityID
    Child.Description

    The link between these is from Parent.ID <-> Child.ParentID.
    The Child.PriorityID field is maintained, so that the first child record (for a given parent) is 1, the second is 2, etc. This is maintained by the frontend of the application.

    What we want, is to be able to pull a grid from the Parent table, which shows the Child.Description values as columns of the Parent table. By this, we will define how many we want to see (Say, the first 5), and add 5 new calculated fields to the Parent table when creating our query, which will pull back the appropriate child.Description (based on the combination of Child.ParentID and Child.PriorityID).

    I havnt been able to do this yet. Can anyone suggest how I can do this?

    Thanks.

     

     

    Wednesday, November 10, 2010 3:41 AM

Answers