Google threads on this site "script muliple field search site:forums.filemaker.com"
Contact Number is an ID # used in relating the 2 tables?
The search layout will display the results?
The search layout will displayed in a popup window? Or in a Custom Message?
Why is the contact number recorded in two different fields? You may find that there are a number of advantages to combining your data in a single table instead of having it in two.
Given that you have two tables with the same info, you may want to use a method that does not require any scripting or performed find. You can define a field for looking up the contact number and link it in a relationship to both of the tables that you want to search. Then you can place two portals on your layout. When you enter the contact number in this match field, any related records will appear in the portals. A button in the portal row of each portal can then use Go to related records to take you to a detail view of that record.
There are 2 different tables with different fields (for different purposes) that have different records.
I need to enter number in the field on search layout, search, and have the results from both tables on a new "results layout".
Results layout should look like smth:
And that could be two portals listed one above the other.
But I'd use 1 table with the number in it and, if necessary, link it to the other two for the "different purposes". That would give me a single table to search instead of two.
And if you can't get two portal's to work, you'll need to set up a third table anyway so that you can import the data from each found set into a common table for listing in your report.