Question - regarding a FIND request

[JLEEINC]

I have basically an inventory management database (has Name, Type, Product Name, etc for fields)... and have a field for [sOLD] pieces of inventory ... what i'm trying to do is, is set the "Find" button, so that it searches the database based on whatever criteria you put into a given field, (Name , search for Tiger Woods for example) and have it ONLY show records for Tiger Woods that are NOT sold (omitting each record that is declared [sOLD]) ...

my current set up is -> Button Setup is set to 'Enter Find Mode' and it searches fine (but finds ALL inventory including the SOLD pieces) ... when i 'Specify Find Requests' and set it to Action>Omit Records and Criteria>LineItem2::Sold = SOLD

BUT when i check this box for Specify, and then try to search for "Tiger Woods" it shows ALL records (not just tiger woods), BUT it does omit the SOLD Tiger Woods pieces ...

is there something i'm missing with regards to it showing ONLY Tiger Woods (search criteria of course, as tiger woods is only an example) and omitting the SOLD pieces? well i guess there has to be or i would not have this problem, lol

Thanks for any and all help!

Jerimy.

[Ender]

Use a script that sets the desired criteria. It might look like this:

Enter Find Mode[]

Pause Script[indefinitely]

New Record/Request

Set Field[sold;"SOLD"]

Omit Record

Perform Find[]

Then have your button perform the script.

[JLEEINC]

I appreciate the heads up, although it does not seem to be working .. that said, here's a screen shot of the script, is there something wrong? i think i followed your direction ...

thanks for any additional insight and/or help!

Screenshot

Jerimy.

[Ender]

Your Set Field[] is not correct. Don't put the "SOLD" in the target field's repetition, put it in the Calculated result section.

[JLEEINC]

i feel silly asking, but where exactly is the Calculated result section?

thanks again for your help!!

Jerimy.

[Ender]

When you select the Set Field[] script step in the script window, the option will show at the bottom. Then click the button to go in.

[JLEEINC]

ok for the Set Field[] , do i also set the "Specify Target Field" ? as well as the "Calculated Result"? ... as i've tried messing with both of these and coming up with the same results, its finding the "tiger woods" but showing ALL results for him, not omitting the SOLD pieces., but i'm sure i've got something slightly off.

what i'm trying to omit (from the search results) is from the table 'Line Item 2' , field 'Sold' ...

i know this cant be tough, but like anything without the proper knowledge, its harder than it should be ... i really appreciate your assistance, and let me know when i've tested (your patience) too much as i completely understand.

Jerimy.

[Ender]

The 'target field' is the target of the Set Field[], in your case Line Item 2::Sold.

[JLEEINC]

here's what i have and it's still showing sold items:

screenshot: http://jleeinc.com/screenshot-fmp2.jpg

thanks,J.

[Ender]

It's still missing the Calculated result part on the Set Field[].

[JLEEINC]

ok, clearly im misunderstanding somewhat ... i know where to put in the calculation , but what IS the calculation formula? i dont know what to put there ... again sorry for my ignorance ... some of this i breeze right through and then get stuck on what seems like simple stuff lol ...

you dont by chance have msn or yahoo or aim chat do you?

[email protected] , [email protected] or jleeinc1 (aim)

prob could solve this in about 30 seconds either way i really do appreciate your time! Jerimy.

[Ender]

i know where to put in the calculation , but what IS the calculation formula?

In the calculation dialog, just put in the text you want to set in the field. In this case, "SOLD" (with quotes).

Edited September 26, 2007 by Guest

[JLEEINC]

LMAO, like i said "getting stuck on some of the simplest things" ... i simply was not using quotes around the word "sold" and it was prompting me to do something else

FIXED!!

YOU ARE THE MAN - THANK YOU SO MUCH FOR YOUR TIME and certainly your PATIENCE!!!

Jerimy.