jdonahue

How would I set up the ref that you are referring to? I have all the files in about 20 different folders but I can easily put them all together. Thanks for the help.

I thought of that, but I have over 5000 pdf's that I would need to insert into a container field. I thought using spotlight to find the pdf might be less work. I got a script working that finds a specific file. It is tell application "Finder" set the search_string to "46280" end tell tell application "System Events" keystroke " " using {option down, command down} delay 1 keystroke search_string delay 1 end tell What I want to do is instead of searching for "46280" I want to paste the contents of the clipboard into spotlight.

I am trying to create a script that does the following 1) copies a serial number contained in a field in a FMP table 2) opens spotlight, pastes the copied serial number and searches for that serial number (which is the name of a pdf file 3) opens the top hit in spotlight which will be the pdf file I assume I need to use either Applescript or Automator to get this done. I have played around with it with no luck. Any help would be appreciated. Thanks.

Thanks for the tip. It works perfectly now.

I have a database listing contact names. I want to create a report that consists of all the cities listed in my database with a summary field displaying the total number of contacts in that city. I do not want to display each individual record in this report, only a list of cities with the corresponding count. I have been able to create a subsummary field with the contact count, but I cannot figure out how to list each city only once in the report. Any help would be appreciated.