5 Replies Latest reply on Mar 5, 2010 5:07 PM by philmodjunk

    Need help with specific report design

    whardy7

      Title

      Need help with specific report design

      Post

      I need to print a complex report on 4x6 cards, so real estate is a premium. It is a project for a non-profit hospice-type group. 

      Here is the design simplified: 
      Households: ID_HH, LastName 
      FamilyMembers: ID_FM, ID_HH, FirstName, Category (related to HouseHolds through ID_HH)
      Visits: ID_VI, ID_FM, Date, Notes (related to FamilyMembers through ID_FM)

      I need to print each household on a separate card and include the household data, then list a family member with any visits they have received (there may or may not be a Visit record for that family member), then the next family member and related visits, etc. I also need to be able to print only those family members in a given health category. 

      I have racked my brain trying to do this different ways. I would appreciate any help in accomplishing this. Let me know if I am missing any vital information to describe the project. 

      whardy7