I would like to be able to "import" a list of unique criteria all for the same field to create a multiple request find.

The goal would be to find all records that match the criteria in one pass. In doing this it will allow me to associate product names with the codes if someone sends me a list of product codes with no names.

In this case it would be product codes like while each one creates a new request:

11-06-01

42-20-02

07-01-03

99-99-99

80-02-07

80-11-01

98-01-01

98-01-02

10-15-01

10-17-02

18-06-02

18-08-02

18-10-01

18-04-01

18-02-02

18-01-02

42-05-02

41-13-02

25-04-01

05-00-04

A bit of background info: in order to perform this find, each product code will need to be on a separate find request. This itself isn't hard, just a bit of clever scripting.

So the process for finding the products would be to get the list of codes, put each one into a separate find request and perform the find.

As far as importing find requests go, something might be possible. I would import the list of codes into a global field, then process the global field to put them into separate find requests.

Be aware that FMP's 64,000 character text field limitation will restrict the number of codes you will able toimport and process at any one time.

I've attached a small FMP 5/6 sample file that includes a script that parses a field and converts it into multiple find requests. it's not pretty but the script is well documented -- beware though, it is a complicated process and it assumes the values are paragraph delimited.

parse.fp5.zip

Hi,

Did anyone made this kind of find for many fields ?

Because this is great.

Thanks Vaughan.

Bruno