Quick Find and regular "finds" are "starts with" pattern matching. So one option is to change your portal search to a "Starts with" portal filter instead of pattern match.
In a regular find, you could achieve the same results with *CO*, but note that you can't just put the same text into your global field and get the same results due to the different search text used to produce the same results, you'd have to use two fields. And you can't use such wild cards with a quick find anyway.
But are you sure that you really need to have your found set match the records shown in your portal? That seems a bit redundant.
Like always thanks for your Time Phil,
The reason for having the same fields in the portal is that the records are all very similar, with small differences, and sometimes the user has difficulty with cycling threw all the records and find the right one. (But only in this case, in my other portals I use a find within the portal, works fine).
If I use "start with" in the portal filter, does it only check the first word or also the second or third word in the field (in the portal)?
Thanks again Phil,
You are correct, you still cannot get exact results with a "starts with" search portal for the reason you specified.
But you could set up a found set of just one record and move from record to record by clicking a button in the portal row. You can even come up with "forward, back" buttons that cycle through the same records shown in the portal without having to cycle through them as a found set.
On the other hand, a script could loop through the rows of your portal and build a list of primary keys to use to update the current found set to match that list...
Thanks like always Phil,
I like your last suggestion and build a found set of primary keys to get the same records in the LayOut. As I wrote, it is only in this particular case. In my other LayOuts I use your earlier suggestions on the forum to find records with PatternCount in the portal and go to the appropriate record in the Lay Out by clicking on the record.