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

Summary

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

Product

FileMaker Pro

Version

11.0v2

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

Workaround

No workarounds

DiverDB_problem.gif

Outcomes