How to search between two different tables?

[K3lso]

I have two tables containing one field each one. Now, I want to create another window (table) that contains a single field where I would write in the word I want to search and when I click the search button it will return, in two portals, the matched records. (each portal for each table). How can I do this?

[K3lso]

I have two tables containing one field each one. Now, I want to create another window (table) that contains a single field where I would write in the word I want to search and when I click the search button it will return, in two portals, the matched records. (each portal for each table). How can I do this?

[K3lso]

I have two tables containing one field each one. Now, I want to create another window (table) that contains a single field where I would write in the word I want to search and when I click the search button it will return, in two portals, the matched records. (each portal for each table). How can I do this?

[Vaughan]

If you are displaying related records it's not a search as such (which implies a Perform Find step) so your initial question is misleading.

What you really want is a filtered portal: not difficult. One global field to contain the "search" value. Two relationships, from the portal to each table. Two portals based on these relationships.

[Vaughan]

If you are displaying related records it's not a search as such (which implies a Perform Find step) so your initial question is misleading.

What you really want is a filtered portal: not difficult. One global field to contain the "search" value. Two relationships, from the portal to each table. Two portals based on these relationships.

[Vaughan]

If you are displaying related records it's not a search as such (which implies a Perform Find step) so your initial question is misleading.

What you really want is a filtered portal: not difficult. One global field to contain the "search" value. Two relationships, from the portal to each table. Two portals based on these relationships.

[Rob 7 Collins]

Vaughan, do you know how to have a search span all related tables in a tree?

[Rob 7 Collins]

Umm, nevermind. I thought that since when I put a child field on a parent layout I can only view the first child record, that the search wouldn't work. Turns out it works anyway.