search through several tables

[effa]

I have a search layout and 1 field in it.

Also I have 2 tables. I want to enter some data to the field and then script which will look through the specified fields in both 2 tables to find this data.

After this I need to get the results (all the records that were found) on one layout.

How can I do this?

 

I.e. the results should look like:

table 1: record 2, record, 3, record 10.

table 2: record 3, record 15, record 16.

 

[IdealData]

If the 2 tables are unrelated then you cannot display the found set from both tables on one layout because a layout can have only one context.

 

You can, however, display RELATED records as a portal.

 

Have you learned how to make tables related yet?