Hi

I'm getting rather confused over a 'find' script, I wish to write for FM 8.5
Advanced.

I have a table which includes three fields, these three fields contain a
client's name or client's contact names. What I want to do is perform a find
where entering a name displays a list of all records that contain the
entered name in any of the three fields.

So far the only way I have managed to do this is create an additional field
which automatically contains the three fields, and performing the find on
this field. But obviously this is a bit wasteful of disc space, as it is
duplicating data.

Sorry if this is a bit of a basic question, but the many options available
to perform a find are confusing me!

Many thanks.

--
Jeff Wright

Jeff,

You have done the right thing in my opinion. I don't agree that putting the
fields together is a wastefull use of disc space. With modern systems the
addition of one field should never constitute a problem. If it does create a
problem then your harddisk is too small for even running the file without
the new field. Be prepared for far and far larger files then a file with
three fields. The largest file I have is 30Mb and this is by no means a
realy large file.

Ursus

"Jeff Wright" <jeff (AT) jeffwright (DOT) demon.co.uk> schreef in bericht
news:emdafg$rvg$1$8300dec7 (AT) news (DOT) demon.co.uk...

As long as you're scripting the find:

Enter Find Mode
Set Field1 to ValueToFind1
New Record/Request
Set Field2 to ValueToFind2
New Record/Request
Set Field3 to ValueToFind3
Perform Find

Otherwise, I agree with Ursus. The single calc field is not a significant waste of space.

Matt

On 12/21/2006 01:43:55 "Jeff Wright" <jeff (AT) jeffwright (DOT) demon.co.uk> wrote: