AnsweredAssumed Answered

Incorrect Data

Question asked by director@charlesmoore.org on Oct 12, 2011
Latest reply on Oct 18, 2011 by philmodjunk

Summary

Incorrect Data

Product

FileMaker Pro

Version

11

Operating system version

OSX

Description of the issue

Hello...Maybe someone can help me with what should be a very simple database. Im trying to relate Places (PN) to Humans (HN).  The relationship want to say, "Many photographers (HN's) can provide photos of a single Place (PN)."  So I've set up a Photo Table and a join table to fill Portfolios.  The rule is each Portfolio can ONLY be assigned to ONE HN and one PN. 

So in the end, one should be able to look at a PLACE (PN) and see all the photos that have been shot by HN's, through the related Portfolios. 

But when I look through a portal on the PN side, I see all the photos, but it does not find the related HN correctly.  (But when I look on the HN side, it correctly finds the photos assigned through their portfolios. 

Can anyone help explain why this relational path might be faulty?

MANY thanks!

Screen_Shot_2011-10-12_at_11.42.36_AM.png

Outcomes