Hi. I have find criteria that works when I input it manually, so I know there is matching data. When I place that criteria in a find step in a script it returns no records.

I have a layout attached to my 'Trips' table. The one field on that layout is called 'BillToDropdown' and it is an edit list that pulls all client names from table 'BillTo'.

I want the user to pick a client from the list and run the find script (from a button.) The script then adds another criteria, so this is how it looks in the script:

Perform Find[Restore] ... where the specified criteria is:

Trips::TripStatus = "To Be Billed"

AND

Trips::BillTripTo = BillToDropdown

I know that's not a whole lotta data, but can anyone see where I am off?

Thanks

Kurt

When doing a RE-find I noticed only the field name I want the value to be taken from appeared in the field I want to find against. So I gave it a fully-qualified path so it now reads:

AND Trips::BillTripTo = Trips::BillToDropdown

Still returns no records.

I am pretty sure I am not qualifying the field properly in the Specify Find Criteria dialog. I think it wants to find 'BillToDropdown' as actual data, rather than a field name. Can anyone point me to how you steer Specify Find Criteria to accept data from another field?

Thanks

Kurt

As you, I can't seem to get the find criteria to use fields as search criteria. I posted a queery a few weeks ago and didn't get a solution. My solution is to use globals on the find layout. User selects the find button, is taken to a layout containing globals in browse mode. After entering data, the user selects "execute search" and a script, checks for empty fields, then, find mode, setfield (text fields: global fields), perform find, go to layout XYZ. (in a nut shell). Gook luck. GW.

Thanks Oldsneekers:

I *think* I follow you:

"User selects the find button, is taken to a layout containing globals in browse mode. "

But these globals are empty, right?

"After entering data, the user selects "execute search" and a script, checks for empty fields, then, find mode, setfield (text fields: global fields),"

So the user populates these global fields with his/her search parameters and the setfield [color:"red"] COPIES that user-entered data into the appropriate find fields? Is that it?

I wish I could find a good book (none published yet) or a decent reference. Only one I found online has a broken payment gateway. This shouldn't be this hard.

Thanks

From what I can see, Perform Find [Restore] should only be used for literal finds or to save the last performed find as a literal find. Otherwise use

Enter Find Mode [ ]

Set Field or Insert Calculated Result steps to specify the criteria

Perform Find [ ]

Thanks Queue:

I will have to try that. Once I place find criteria using the specify button, Find [Restore] becomes the default. So I will definitely try NOT setting criteria using specify but will instead use other script functions.

Will post back with success/failure.

Kurt

Thanks for the help, all. Couldn't get it working just right so have to move on from here. Maybe I can revisit this method later.

Kurt