Search Help

[shadyb76]

I have looked in the forums for this information but I did not see anything that would help me or maybe I am just going about the wrong way. I have many groups of people and I need to be able to search for all of them from one line.

Here is an example: Group1 has persons ABC

Group2 has persons DEF

Group3 has persons GAE

In the data base they are defined as person1=a person2=b..... and so on and so forth.

I would like to search for all people from one line in search mode. Please let me know if this is possible. Any help would be greatly appreciated. Thank you.

[Ender]

This isn't quite clear.

Can you try again using sample names instead of letters and give an example of the type of search string you were hoping to enter and which People (or Groups?) you would then like to see returned.

[shadyb76]

Sorry if i was unclear... basicly i have teams:

Red Team = John S., Dave A., and Joe P.

Blue Team = Kelly R., Kim P., and Brian L.

Green Team = John S., Brian L. and Feven Y.

They are listed in the database as:

Red Team = person 1, person 2, and person 3

Blue Team = person 1, person 2, and person 3

Green Team = person 1, person 2, and person 3

I have 200 team like this with the same person being in multiple groups. I would like to search from the "person 1" line and see all the resutls of what team that person is on no matter if he is person 1 2 or 3.

Hope this explains it a little more. Any help would be greatly appreciated.

Edited March 13, 2007 by Guest

[Ender]

They are listed in the database as:

Red Team = person 1, person 2, and person 3

Blue Team = person 1, person 2, and person 3

Green Team = person 1, person 2, and person 3

What is the structure for this?

You should have a Team table, a Person table, and a Person-Team join table. Then the solution is simply to show the join records in a Person-Team portal on the Person layout. No Find is necessary.

[shadyb76]

Thank you, that should help i will give that a try.

Much appreciated.