Search engine multiple fields
I´m still working on different search layouts.
Lets think we have a "names table" with 3 fields: Id, Name and Last Name
Created a new layout to search using a new "global table" with 3 search global fields: globalId, globalname, globallast
Created a relationships like this: Id=globalId, Name=globalname and Last Name=globallast
Then created a new relationship with "names table2" to create: IdXglobalId
By using the 3 fields on "global table" and working on a search layout, I used the fields with drop-box and auto-complete with value list based on Id, Name and Last Name. Then I created a portal based on "names table2" to show all records.
Now, I really don´t know how to create a script for every field on the search-drop box fields, to show only matched records in the portal, i.e. on field globallast you write "Smith", and the portal shows only "smith joseph", "smith anne", "smith jack"... So I can click on the preferred record to return to the original layout.
And also, being able to set globalname: Anne, globallast: Smith, and the portal shows 2 records: 3.Anne.Smith and 147.Anne.Smith
As always, thanks for reading and for your help.