AnsweredAssumed Answered

Creating a Relationship between two Tables that shows the records that don't match in a Portal

Question asked by cameraeyes on Jul 22, 2010
Latest reply on Aug 8, 2010 by cameraeyes

Title

Creating a Relationship between two Tables that shows the records that don't match in a Portal

Post

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?

David

Outcomes