You need to do portal filtering, either with the Portal Filter function in the portal attricbutes or you need to filter via the relationship with appropriate keys in the relationship.
What are the common demoninators for records 1, 12 & 105 ? This is critical to make your requirement work.
The relationship key gets all combinations of 3 numbers from the 5 numbers of each record.
If a record has 1-2-3-4-5 entered
the key gives: 1-2-3
1-3-5 and so on to a total of 10.
With this key I created a relationship inside the same table: key=key ( the same key)
so that the Portal gives me all records sharing 2 numbers
Now, I want to find ONLY the records (outside the Portal) that don't share 2 numbers of any other record.
Hope I have explained my issue and thank you.
Of course my answer contains an error.
where I wrote : "so that the Portal gives me all records sharing 2 numbers..." I should write:
so that the Portal gives me all records sharing 3 numbers (and not 2)
And: I want to find ONLY the records (outside the Portal) that don't share 3 numbers of any other record.
It's really not clear what your current database design is.
On what table is the layout based and how is it related to the portal's table?
I can tell that you have a return separated list of values in a field that you are apparently using as a match field in a relationship.
It's not clear how that field calculates a list of three number text patterns like you show in your example.
Nor is clear why you have chosen to employ this method. Knowing why you have set it up this way, might enable us to suggest a simpler alternative. I've used a return separated key field before and it can be quite useful, but in many cases a separate join table provides the same functionality but with simpler scripts, calculations and layouts.
And what exactly do you mean by "outside the portal"?