1. SEARCHING WITH A POP-UP MENU

Click in the shadow highlighted box beside "Plant Lifeform" to view the pop-up menu. Select a lifeform by dragging with your mouse down the list until the name of a lifeform is highlighted and let go. The field should now show the name of whatever lifeform you selected. Plant Lifeform: Tree Shrub Graminoid Forb

Press this button:

2. SEARCHING A BLANK FIELD

Type trichocarpa to search for all records with "trichocarpa" in their species name: Species:

Press this button:

3. SEARCHING WITH OPERATORS

The database utilizes the functionality of searches in the FileMaker Pro database application. The following table illustrates how to use Claris FileMaker Pro operators in combination with the data you're searching. The operators can be used in combination. Remember to type these operators directly into the search field:

If you want:	Type this operator:	For example:
Greater than what you type next	>	>2500 or >10/12/94
Less than what you type next	<	<40 or <05/06/92
Within the range you specify	...	50...100
Greater than or equal to what you type next	>=	>=0.25
Less than or equal to what you type next	<=	<=50%
An exact positional word match	==	==sage (finds only those words that start with "sage," including "sagebrush" and "sagewort")
An exact word match	=	=sage (finds anything with "sage" in the name (e.g. "Red Sage," or "Sage," but not "Sagewort" or "Sagebrush")
One unknown or variable text character	@	R@d (finds "Red," "Radish," "Rydberg," etc.)
Zero or more unknown or variable text characters	*	*can* (finds "American," "Canadian," "Candystick," "Canyon," etc.)
Literal text in a field	" "	"Silver" (finds "Silver" or "Silvery")
Empty fields	=	= (when you type a single equals sign in a text field, the database will find you all of the records with blanks in that field)

 

Try finding any common name between "Wheat" and "White" by typing Wheat...White in the field below:

Press this button:

Go Back to ESG's Riparian and Wetland Front Page

Go Back to the Database Search Page