Found Records List

[abomb]

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

[Søren Dyhr]

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, 2007 by Guest

[abomb]

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.

[Søren Dyhr]

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

--sd