Jump to content

finding same info on multiple fields


This topic is 8007 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

  • 4 weeks later...

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 !

Link to comment
Share on other sites

This topic is 8007 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.