finding same info on multiple fields

[RET]

Can anyone please tell if and how this can be done?

I have three fields

field1, field2, field3.

If I want create a search layout that will look for the word " Loan" in every field, and do this by date, how would I go about this?

Can this be done?

Basically I have multiple fields that I need to collect this data in a report by one of the choices in Value list.

Thanks,

RET

[andygaunt]

Well,

you have a couple of options.

1. Write a script that takes the information searched from a global and in your find performs new requests and sets the relevant fields with the information from the global.

Enter Find mode

Set Field [field1, "globalvalue"]

New Record/Request

Set Field [field2, "globalvalue"]

New Record/Request

Set Field [field3, "globalvalue"]

Perform Find

2. Create a calculation field of all three fields [formatted as text]

field 1 & " " &

field 2 & " " &

field 3

and then search on this. This will return any record where the information contained in the calculation exists in any of the three fields.

HTH

[glaser_david]

Andy,

Do you know how many new record/request are allowed in a script?

Is it the same as in a manual find?(unlimited)

Thanks,

David

[andygaunt]

David, you can have a lot of new requests in a find (I think unlimited, but not sure.

I just took one database to a hundred new requests and it was ok, once you get past ten when filemaker prompts you that you are in find mode), but this is sometimes counter productive, especially if you are coding a lot of information in the script.

What happens if you then want to change 1,2,10 or more of your requests.

Better to create a calc of all the required fields, then use this for searching on.

Then if you do need to add a field, you are doing it here.

Keeps the script shorter as well.

[ppo]

Looking for an information in several fields is quiet simple as you explain it, except when the fields concerned are date fields ! which in my case never operates, the answer being always "no field ..."

I have found some solutions but none of them were elegant and always heavy to use !

If anyone gets a beautiful idea, he's welcome !