Creating a Relationship between two Tables that shows the records that don't match in a Portal
I am struggling to create a relationship between two tables so that I can display in a portal a list of records in one database that are not related to the records in a portal.
For example, if Table A has a number field that has 10 values from 1 to 10 and Table B has a number field that has 10 values from 5 to 15. I would like a portal to display values 1-4 from Table A.
I have upgraded to FM 11.0 and am able to use filtering to achieve this but I would like to incorporate this in a database that runs on FM 10.0. Any suggestions on how this can be done?