Malcolm Garbett

Thanks. I'm glad I'm not the only one who doesn't understand the script. All "inherited" and I'm not sure if "best practice" was always followed. I've created the relationship and that's certainly helped. There is a checkbox where the user selects the application codes they need. Now I have it working with == if I select one box it works, if I select more than one no data is returned. Does FileMaker handle this sort of thing?

Thanks for the tip. Just so I'm clear does this mean that there is no solution with the current script? No "simple" edit to produce exact matches? #Application filter If[ReportsandFilters::FilterApplication = “”] Else Constrain Found Set [Restore] Loop Exit Loop if [$Count = WordCount(ReportsandFiltersList::FilterApplication)] Set Variable [sCount; Value:$Count + 1] Set Variable [$App; Value:MiddleWords(ReportsandFilters::FilterApplication ; $Count ; 1)] (I'm coming from SQL so have the LIKE keyword for contains and the = for exact matches in my head.)

Struggling with what I thought would be a “simple” change. As mentioned in previous posts, I have inherited a FileMaker deployment developed over several years. There is an “Order Book” table Behind the “Order Book” table, is a table that applies filters. So the user can go into “Order Book”, click a link that gets them into the Filters Layout, make selections, apply filters and “good to go.” This is my issue. One of the filters is a custom values list. The custom values match data from the “Order Book” table in an Application field. (For application, think of product range.) Example current value = PRO. We actually have, “PRO-STD” and “PRO-SPEC” Easy enough for me to add those two and remove the original “PRO.” However, using the “contains” rule, checking either box returns all “PRO-STD” and “PRO-SPEC” records, which I don’t want. Now, looking at the script – see below – I can’t figure out how to change the $App variable to what I need. Which is to still be able to select multiple Application Codes, BUT have exact matches against each value. #Application filter If[ReportsandFilters::FilterApplication = “”] Else Constrain Found Set [Restore] Loop Exit Loop if [$Count = WordCount(ReportsandFiltersList::FilterApplication)] Set Variable [sCount; Value:$Count + 1] Set Variable [$App; Value:MiddleWords(ReportsandFilters::FilterApplication ; $Count ; 1)] Just to be clear, we have around 10 codes and everything is working fine now, apart from the ability we need to select exact matches on all of them rather than “contains.” All help and pointers in the "right direction" gratefully received.

Thanks. Very clear. Will have a go later in the week.

Hi all, Background: Starting a new job where they are using Filemaker amongst other things. Downloaded the 30 day trial. I went to connect to a SQL database but it doesn't appear as a driver. Go to the site and was given a "trial" driver which is for a Mac. Question: On my laptop at home - Windows 7 - where I have a SQL Server (2008 R2) instance running, how can I connect to it from my Filemaker (trial version) in order to import data?