AnsweredAssumed Answered

Search with multiple "And/Or" conditions

Question asked by rtolliver on May 12, 2015
Latest reply on May 13, 2015 by philmodjunk


Search with multiple "And/Or" conditions


I'm from the MS Access world and I'm porting an Access 2010 database over to FileMaker Pro (FM).

Need help with constructing a script that can search a table occurrence(A) based on selections from 3 different fields within table occurrence(A).  Table occurrence(A) contains information for Shirts and the three dropdown fields are "Type", "Color", and "Size".  In my original Access 2010 database I used VBA to construct a SQL script that ran each time any field select was made and also updated the current layout data.  I'd like to create something similar in FileMake Pro if possible.

Any suggestions?