1 Reply Latest reply on Jul 2, 2014 2:01 PM by philmodjunk

    Filtering records on layout - constant or modifiable



      Filtering records on layout - constant or modifiable


           I have a table called FABRIC INFO following fields:

           - Fabric_ID (text, unique no)

           - Category (text) ..to select from value list: Knit, TShirts and AllOther

           - Cloth_Type (text) to select from value list: Woven, Leather, Yarn, Jersey and Lining

           - Season (text)  ..  AW 2012, SS 2013, AW 2013, SS 2014 ....

           and then I added another field on the same table called;

           - Current_Season (global field, text)


           Let's say if I want to work on any records with Season field = "AW 2012" by typing in "AW 2012" in the Current_Season (global field).

           On a FABRCS layout, I want only "AW 2012" and Category = "AllOther" records to be displayed while the global field of Current_Season = "AW 2012". 

           I want to set up a script trigger buttons to show Cloth_Type (easy enough) but only matches to the Current_Season, so omitting all other seasons but showing only AW 2012's "matches the Cloth_Type = "Leather".

           On a Knit layout, I only want records showing Category = "knit" and only displaying whatever the varible is in "Curresnt_Season". and when I enter find mode, I don't want keep typing in, the season, category, cloth type etc..

           What's the best way of setting this up?

           Can a script trigger applied to layout? Or do I needs to filter / match records using another table?

           I mainly work on one of the season, but on a odd time I need to go back to past season, so I don't want keep typing in all the detail manually by entering Find Mode.


           Any suggestion appreciated.

           Kind regards, Kaorin