AnsweredAssumed Answered

Filtering records on layout - constant or modifiable

Question asked by Kaorin on Jul 2, 2014
Latest reply on Jul 2, 2014 by philmodjunk


Filtering records on layout - constant or modifiable


     I have a table called FABRIC INFO following fields:

     - Fabric_ID (text, unique no)

     - Category (text) 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