Hi:

I used "-Find" and got subset data from the current database, then I want to use other criteria working on this subset only. Does anyone know how to do this?

Thanks!!!

Catty

quote:

---

Originally posted by CyberSport:

Well, you can't do a "find" on a "find", if that's what you mean. The only way I do this is through scripts (which are too long to use over the web) where you export a found set to an empty database and then do a find on that set and plug those results back into a find on the original database.

Anyone else have any ideas...?

bevin

---

It depends what should be the "work" on the find set. If you want to just display and set single found item that is easy. In other cases CyberSport advice idea is the best one around.

quote:

---

Originally posted by Catty:

I used "-Find" and got subset data from the current database, then I want to use other criteria working on this subset only. Does anyone know how to do this?

---

Haven't tried this myself, but it may be worth some experimentation:

Let's say you have a standard search form in your -Format file. Under normal circumstances each time the form is submitted it generates a new, clean search.

But, how about if you employ the [FMP-CurrentFind] tags?

Here's an example (off the top of my head):

code:

---

Narrow Search:

<form name="SearchForm" method="post" action="FMPro">

<input type="hidden" name="-DB" value="database.fp5">

<input type="hidden" name="-Lay" value="layoutname">

<input type="hidden" name="-Format" value="results.html">

[FMP-CurrentFind]

<input type="hidden" name="[FMP-FindFieldItem]" value="[FMP-FindValueItem]">

[/FMP-CurrentFind]

<input type="text" name="Field_1" value="">

<input type="text" name="Field_2" value="">

<input type="Submit" name="-Find" value="Search">

</form>

---

Again, this is completely off the top of my head. Hope you can get it to work!

You'd do it in exactly the same way you'd do it in the FMP Clinet. In the client you perform the first find, then choose the Modify Last Find command and add or modify the requests. This requires an understanding of how FMP uses find requests which most people don't have: use multiple Find requests to perform OR searches.

On the web, you'd have to build a form that genereated the provious find (the [FMP-CurrentFind] code would be good here) and offer the user an interface that allows them to add other suitable refinements.

CyberSport's suggestion to export into another database is the most creative I've ever heard! It *might* work in a single-user situation but I cannot see it even being possible in a multi-user environment. And certainly not possible over the web. The Bridge is on the right track.

Well, you can't do a "find" on a "find", if that's what you mean. The only way I do this is through scripts (which are too long to use over the web) where you export a found set to an empty database and then do a find on that set and plug those results back into a find on the original database.

Anyone else have any ideas...?

bevin