Taig McNab

Beautiful! Just what I was trying to do. Thank you... I've gained just enough new knowledge to be dangerous now Regards, Taig McNab

Hi, Could you tell me how you would do this - its exactly what I've been trying to do: I have a set of records and would like a button to take the value of a particular field and display all other records with a matching field - exactly what the right click "Find Matching Records" does. How do you get the data out of the field and then in to the find query? Is it along the lines of: Copy [select;Field] Enter Find Mode [Pause] Set Field [Field; #what goes here?!#] Perform Find [] Any help would be much appreciated. Regards, Taig McNab

Thanks - for some reason, I can't search the forums at the mo. I'll take a look. Cheers Taig

Hi all, I was just wondering if there was such a thing as the right click action of "find matching records" that you could use in a script? I'm after something like: Go to Field [target field] Find Matching Records Any ideas how to script this? Regards, Taig McNab

Søren, Brilliant! That script did the trick!! I spent about 3 hours yesterday trying lots of combinations of extending found sets but had no joy. Thank you for your help. Taig

Hi LaRetta, Slightly missed I would like to keep the original find in place: eg. 1. click "view task by person" and type in "Bob" 2. Bob's outstanding tasks pop up (the first find script has found all Bob's tasks and then constrained and omitted the completed tasks) #this is the problem bit: 3. click a "view all tasks" button which then shows all Bob's tasks including the ones that have been completed. Show All Records would show all tasks from everyone, not just Bob. I could easily do it the other way (show all tasks then have a button to constrain) but the majority of the time, we will not need to see the completed tasks, so I just wanted to make the UI a bit easier. Best, Taig

Hi all, I've been trying to figure out if this is possible: I've got a list of tasks assigned to people and have a search button to look for outstanding tasks for a particular person. Completed tasks have a timestamp field filled in with the date/time of completion. The find script pops up a box asking for a name, finds all records with that name and then constrains the search to omit records with data in the timestamp field. Is there a way of "unconstraining" this search to show the full list including completed tasks? I'd like to have a "show all" button on the search results page. Regards, Taig McNab

Hi all, I've searched archives and can't find much to help with my problem: I am building a database of tapes which all have unique ID numbers and am wondering if there is a way of automatically adding the * to a find. Many of the tapes have letters/numbers that could be ommitted when searching eg. IS1000394 - it would be easier just to search for 394. So in short, is it possible to automatically add * to the beginning of a search? Any help would be much appreciated. Thanks Taig

Sorry, I didn't specify the way my external file is arranged: The file is coming out of a video editing application (Avid if you know it...) and is an entire bin which has a list of multiple clips and associated information. Eg: a bin may have 30 clips in all named differently with other information such as which tape the clip came from, which hard drive it was saved to, how long it was etc. all of which can be exported from Avid with couple of mouse clicks. You can then export a jpeg of each of these 30 clips with another couple of clicks. For even a short project in Avid, you could end up with hundreds of clips and jpegs. In short, I was trying to get a way of pulling everything in to FMP without having to import one at a time. I can attach an example if you would like to take a look... Thanks Taig

Hi all. I've been reading posts all day and although I have solved a couple of problems I was having, I can't quite get my head round the final hurdle in a databse I'm making. I'm fairly new to all this database/FMP stuff so your patience is much appreciated! I currently have the fields in my table populated by importing tabbed data out of another piece of software (video editing), one of these fields is a