5 Replies Latest reply on Mar 31, 2014 8:58 AM by GuyStevens

    Layout design (report?) for displaying / printing / emailing specific fields in records if a any of...

    mchancevet@gmail.com

      Title

      Layout design (report?) for displaying / printing / emailing specific fields in records if a any of a set of of conditions are met.

      Post

           G'day,

           I am having difficulty conceptualizing a structure/design for a layout. I am on FM adv. 13. My  DB records personnel (teaching staff) and I need to generate reports that list names of staff if they are out of date on first Aid training and a  long list of other expiry date based conditions. I need the layout to display only those fields that are actually out of date  and the name of the staff member.

           My data (expiry dates, names, contact details) is all held in one table.I can't see how to structure the layout . I think it will be a list. I seem to have real difficulty getting my head around finds and found sets in layouts

           a rough example follows..

            

      John Smith 

           First Aid - 2/3/14

           Safety induction annual - 3/3/14

           Working with Children police check - 2/3/14

            

      Joe Doe 

           Safety Induction Annual - 12/12/13

            

      Jane Doe 

           First Aid - 12/11/13

           Perform CPR - 12/11/13

            

            

           Thanks for any help.

           Morgan