You'd never know that I'd been doing this, on and off, for years. When you're just building dbs for your little organization, some things never come up.

I want one record and only one record, for each instance of a serial number [this db is storing artwork for some, but not all, records in a related db]. So I want a script to come in, do a find for serial #X. If it finds more than one, it returns a custom "Hey, I found more than one" dialog box. If it finds one, it shows me that one. [both of these work fine.] If it finds none, I want it to create one - but I want to skip the dialog box that the software generates, that reads I have not found any records. Want to Cancel or Modify your find?. How do I do that?

Presently using FMP8 Adv.

Edited October 1, 200619 yr by Guest

Oh right, i thought you wanted something else, but re-reading the post makes more sense...

Just insert: Set Error Capture[On] at the start of your script

See? I'm a little embarrassed that I didn't know that but now I do. Thanks.