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.