1 Reply Latest reply on Dec 12, 2016 1:41 PM by philmodjunk

    Special layouts for small subsets of database

    ebear

      I need layouts for subsets of the whole database which is about 700 people.

      For instance maybe 20 of which are in the fire dept. and for which I need those relevant details. 

      Also I make ID cards with FMP.  I have (at present) seven departments with their own designs.

      I don't want somebody from the other side of the state, who's basically just in my phone book,

      showing up in the Road Dept. and Assessor Dept. and Fire Dept. IDs.

      Right now I just have each department's ID stuff in its own flat file, and the fire dept. stuff is not even in the DB.

      How do you do stuff like this?  I have FMPA 15.

        • 1. Re: Special layouts for small subsets of database
          philmodjunk

          If I understand your request, you want to put everyone into a single table but then want only subsets of that table to appear on certain layouts customized for that group.

           

          You can set two different script triggers to help with that: OnLayoutEnter and OnModeChange.

           

          With both, you can perform a script that constrains the current found set to only records of the specified group. OnLayoutEnter might just perform a find for all records of a given group at your option. But for OnModeChange, you want to set it so that you get that constrain each time the window enters find mode. This allows the user to perform finds for records and then their results are automatically filtered down to just those of the permitted subset.

           

          You might also set up one table for all contact info--such as names and a different related table used only to record relevant details specific to one sub group.