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?

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?

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?

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.

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.

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, do you know how to have a search span all related tables in a tree?

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.