Jump to content
Sign in to follow this  
RET

finding same info on multiple fields

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

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

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 !

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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