Eric Schult <[log in to unmask]> reports on the Dartmouth Advanced Script List: > I'm converting some FMP 5 scripts to FMP 6 in OS X and dealing with the > broken "whose" command that has been mentioned so many times before on this > list. Mr. Schult: I don't know what issues you're having with this, but the following script works correctly for me in FMP 6.0v4 and OS X (10.2.3)--watch the line wraps: tell application "FileMaker Pro" show (every record of database 1 whose cell "x" contains "y" and cell "x2" does not contain "y2") set somevar to get data of every field of document 1 end tell Or, you could use this syntax: tell application "FileMaker Pro" show (every record of database 1 whose cell "x" contains "y") show (every record of document 1 whose cell "x2" does not contains "y2") end tell --->to return a found set of all records where cell x contains y and cell x2 does not contain y2. Be sure to trap for errors, e.g. no matches, etc. HTH Steven -- Steven H. Blackwell Partner Member, FileMaker Solutions Alliance _________________________________________ "The commitment of our Fathers is now the calling of our time." _________________________________________ The New http://www.FMP-Power.com One Hundred Thirty Six Countries of FileMaker Pro!!