How can I search/find something within 3 different fields and show all of the results in another field. Its hard to explain so heres an example:

Field 1 Field 2 Field 3 Field 4

A x z t

B z y j

C s t u

D u z p

(Imagine its a table w/ 4 colums and 4 rows) :S

If I were to search for z it needs to display A,B,Dbecause they all contain a z.

Does it need to be a script?

Hope someone can make sense of this :S

Any help would be appreciated, thanks

How can I search/find something within 3 different fields and show all of the results in another field. Its hard to explain so heres an example:

Field 1 Field 2 Field 3 Field 4

A x z t

B z y j

C s t u

D u z p

(Imagine its a table w/ 4 colums and 4 rows) :S

If I were to search for z it needs to display A,B,Dbecause they all contain a z.

Does it need to be a script?

Hope someone can make sense of this :S

Any help would be appreciated, thanks

How can I search/find something within 3 different fields and show all of the results in another field. Its hard to explain so heres an example:

Field 1 Field 2 Field 3 Field 4

A x z t

B z y j

C s t u

D u z p

(Imagine its a table w/ 4 colums and 4 rows) :S

If I were to search for z it needs to display A,B,Dbecause they all contain a z.

Does it need to be a script?

Hope someone can make sense of this :S

Any help would be appreciated, thanks

The usual way to do this stuff is to make a calc field that concatenates the fields together, then perform the find on this calc field.

The usual way to do this stuff is to make a calc field that concatenates the fields together, then perform the find on this calc field.

The usual way to do this stuff is to make a calc field that concatenates the fields together, then perform the find on this calc field.

And how would I make a calc field exactly? I am a notal newbie to this!

thanks for your reply.

And how would I make a calc field exactly? I am a notal newbie to this!

thanks for your reply.

And how would I make a calc field exactly? I am a notal newbie to this!

thanks for your reply.

Create a new field and make it:

NewField

Create a new field and make it:

NewField

Create a new field and make it:

NewField

Ok ill try that thanks

Ok ill try that thanks

Ok ill try that thanks

Reading this post a question came to me: What if i want all my records to be displayed in portals... Do I need to create relationships?

Yes. Portals work through relationships.