Hi everyone,

First, not to new to FM but still not exactly an expert. I am trying to create a purchasing database. Our business is unique in that most services are hard to classify in terms of categories. I feel the best way to classify Vendors is by having a notes field that I can type certain industry terms in, then do a *_field search(i've attached a copy of my file). I originally wanted to just relate the g_productSearch and start typing and have vendor's start listing through portal. Couldn't figure out how to make it work so created script to do search.

How can I list the found set in the portal? I know I could do a "report" but I may not want to use every vendor that is found. Any suggestions or links to other posts would be great. Thanks again.

Purchasing.zip

With the portal do you mean the right most of them, I've made some tweaks on your behalf, but you need to instate a clipsave funtionality if you're wishing to stay on freindly term with your users. They might have stored a snappy of their love ones in the clipboard which the scripting tampers with.

Now better methods exist when you upgrade to FM8.5:

http://www.filemakerpros.com/GetNthRecordTAIL.zip

Anways, checkout the tweak I've made:

--sd

PurchasingMOD.zip

Edited June 12, 200718 yr by Guest

Thanks Soren.

Really appreciate you taking the time. I'm not to worried about the clipboard issue because the program is for my benifit and I will be the only one using it but I'll keep that in mind if I try to make it multi-user.

Thanks for teaching me a new trick.

Except this trick is as old as filemaker being relational (from 1995)

--sd