Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Find within Find

Status
Not open for further replies.
yuchieh

yuchieh

MIS
Jul 21, 2000
178
US
I am using FM Pro 6.

I would like to write script that does "find within find results".

For example, find 4 types of Press from a drop down. Then find 5 different status (another drop down) within these 4 types of Press.

Thanks
 
Sort by date Sort by votes
To find records based on multiple criteria in separate fields (a logical AND search), perform a find, specify the next criteria, then choose Constrain Found Set.


1. In Find mode, perform a find to find all of the 4 types of Press.

FileMaker Pro displays the found set in Browse mode.

2. Switch back to Find mode and type the criteria to narrow the search to 5 different status .
3. Choose Requests menu > Constrain Found Set.

The found set now consists of the 5 different status within the 4 types of Press.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mikajake
  • Locked
  • Question
Filemaker Find Requests
Replies
0
Views
54
mikajake
mikajake
ckier
  • Locked
  • Question
Don't allow blank find field
Replies
1
Views
65
haitianfella
haitianfella
nicruediger
  • Locked
  • Question
Using variables to find records 1
Replies
2
Views
80
CryoGen
CryoGen
Yellowspam
  • Locked
  • Question
Where can i finde an ODBC-Driver for FM?
Replies
3
Views
81
larryllama
larryllama
bv2000
  • Locked
  • Question
Find multiple records in a field
Replies
3
Views
67
JeanW
JeanW

Part and Inventory Search

Sponsor

Back
Top