1 Reply Latest reply on Jul 14, 2014 12:36 PM by philmodjunk

    Begginer Question. Creating lists (Not value lists) based on field value.

    GraysonSmith

      Title

      Begginer Question. Creating lists (Not value lists) based on field value.

      Post

           I want to create three seperate layouts in FileMaker to keep track of items.

           1- To show all items in the inventory, regardless of whether they're checked out or not.

           2- A list of items that are checked out (Im assuming a filter based upon the selected field value)

           3- A list of items that are available.

           I understand how to mess around with the layouts and databases as well as some script work. For some reason I'm just not quite grasping this.

           Any suggestions?

        • 1. Re: Begginer Question. Creating lists (Not value lists) based on field value.
          philmodjunk

               1, 2 and 3 could all be shown on the same layout. You don't have to use different layouts for each.

               Show All Records is a menu option and also a script step that can show all records in the layout's table. If your layout is based on the inventory table, that should be all that you need.

               For items 2 and 3, it would seem that you can perform finds with specified search criteria that find the inventory records for all items currently checked out or all items currently checked in.

               These can be finds you perform manually by making menu choices are you can set up scripts to perform the finds for you at the click of a button or at the selection of a value from a value list.

               But the precise details of how you might do that depend on the design of your database--which is something that you did not describe in your first post here.