1 Reply Latest reply on Mar 9, 2010 2:16 PM by philmodjunk

    Creating Reports

    mls504

      Title

      Creating Reports

      Post

      I am a new user to FMP.  I created a credential database.  I created six tables that sorts the data.  The rolodex table lists staff including their departments, and positions.  The remaining five tables specify passes, laminates, parking, t-shirts and tickets each person receives.  I created a rolodex id field to link all tables together.

      I want to create a report by department that will show what staff will receive.  The problem is that each person receives a different number of each type of credential.  I have included 8 repetitions for each field but I only want to show the ones that have information, not the blank fields.  I tried to create sub-summary reports and portals but I am not having success.  

      Please let me know where I am going wrong.

      THANKS