Performing a Global Find in FMPro

Thread View: comp.sys.mac.databases

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Dragon Slayer Mon, 02 Mar 1998 00:00

#727

Author: Dragon Slayer
Date: Mon, 02 Mar 1998 00:00

26 lines
1621 bytes

Hi,

I've got a database of addresses, for each record, I have a
company/business name and contact names within that company as a separate
field; now my question is: How can I perform a global search on all the
fields (selected fields possibly). I have seen it once being done on a FM2
runtime database of apple products, where you go to a find layout with
only one entry field on it and you type a word or phrase and the find
script finds all the records where that word occurs in any field.

I hope I was clear enough in my description.

Thanks for your responses.

Dragon SLayer

-- 
To email me,remove the <<nota>> from to get: <<dragonslayer>>
_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-
Aeronautical Engineers Australia
P.O.Box 238, Willetton W.A., Australia 6955
ph: +61-8-9414-7011  fax: +61-8-9414-7022

Home Page: <http://www1.tpgi.com.au/users/georgea>
_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-

Re: Performing a Global Find in FMPro

#726

Author: Simon Slavin
Date: Thu, 05 Mar 1998 00:00

18 lines
1422 bytes

In article <notadragonslayer-0203981835200001@per-ppp-244.tpgi.com.au>,
notadragonslayer@tpgi.com.au (Dragon Slayer) wrote:

> How can I perform a global search on all the
> fields

Make a calculation that concatenates all the fields that you might
want to search.  Then do a 'find' in that field.

You may or may not want to make this calculation stored and indexed.

Simon.
-- 
Simon Slavin -- Computer Contractor. | Urban "phenomena"?  WTF are urban
   http://www.hearsay.demon.co.uk    | "phenomena"?  Street lamps? --
 Check email address for UBE-guard.  |     mpage@panix.com (Madeleine Page)
My s/ware deletes unread >3 UBEs/day.| Junk email not welcome at this site.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads