FM8.5

I am trying to effect a search based on a field / value list. The
value list is drawn from a table CLASS - in this case I created a
table so that my value list would always appears alphabetically.

My concept is to create a global / value list (again, referencing a
field from CLASS). I do not understand how to effect the search part
of the process. Can you help?

Thanks
Matthew

"Buckbuck" <buck.matthew74 (AT) yahoo (DOT) com> schreef in bericht
news:c7920c55-9e89-4ada-9a00-d93dcddfa075 (AT) h20g2000prn (DOT) googlegroups.com...
Say your valuelist is stored with a global gList
And you want to find a record from the field MyValue
create a scipt
(pseudo-code)
goto search
put value of gList into MyValue
perform find

put a button next to you gList, connect script
select value
click button

--
Keep well / Hou je goed

Ursus

On May 24, 12:52*pm, "Ursus" <ursus.k... (AT) ziggo (DOT) nl> wrote:
Hi Ursus

Not sure I understand.
Do you mean?

Script
Enter Find
Find = gClassification?

Problem is in Find Mode I cannot enter a Find Global value

Sorry, Need more help

Thanks
Matthew

When the database is in Find mode the Global Fields retain their values,
which means you can transfer that data to other Fields as the Find
request, using the Set Field command as you do to normally move data
between Fields.
i.e.

Enter Find Mode []
Set Field [FieldToFindOn; gClassification]
Perform Find []

Make sure you turn off the Restore and Pause options on the Find commands.


BUT,
There is a slight hiccup here. If you're trying to use special characters
(e.g. the range operator "...") or dates, then you instead have to use the
Insert commands.
e.g.

Enter Find Mode []
Insert Calculated Result [FieldToFindOn; gStartDate & "..." & gEndDate]
Perform Find

If gStartDate and gEndDate are Global Date Fields. If they're Global Text
Fields, then you need a bit of extra manipulation to convert the text into
a date.

Helpfull Harry )