Finding something within 3 different fields.

[Extreme Overclocker]

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

[Extreme Overclocker]

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

[Extreme Overclocker]

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

[Vaughan]

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.

[Vaughan]

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.

[Vaughan]

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.

[Extreme Overclocker]

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

thanks for your reply.

[Extreme Overclocker]

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

thanks for your reply.

[Extreme Overclocker]

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

thanks for your reply.

[Lee Smith]

Create a new field and make it:

NewField

[Lee Smith]

Create a new field and make it:

NewField

[Lee Smith]

Create a new field and make it:

NewField

[Extreme Overclocker]

Ok ill try that thanks

[Extreme Overclocker]

Ok ill try that thanks

[Extreme Overclocker]

Ok ill try that thanks

[K3lso]

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?

[Vaughan]

Yes. Portals work through relationships.