AnsweredAssumed Answered

Second portal and self-join doesn't work as expected

Question asked by GerrySmith on Nov 9, 2010
Latest reply on Nov 10, 2010 by philmodjunk


Second portal and self-join doesn't work as expected


FileMaker Pro



Operating system version

Mac OSX 10.5.8

Description of the issue

I built two portals with the associated self join structures to show other records which match my target record using separate criteria (in this case first name and last name). I want to show other records to help my user pick the right diver from a list of (potentially) thousands.

Steps to reproduce the problem

File contains First Name and Last Name fields with self joins on each. see divers-relationships.gif, below

Expected result

From screen shots "Divers-Gerry" and "Divers-Smith" I can see that there are 7 "Smiths" and 2 "Gerrys" in the file. I expected the "Divers-Find" to show 5 of the 7 "Smiths" and both of the 2 "Gerrys".

Actual result

"Divers-Find" shows 5 of 7 "Smiths", but the same "Gerry" repeated twice instead of the two "Gerrys" available in the file.

Exact text of any error message(s) that appear

No error messages

Configuration information

No additional information


No workarounds