AnsweredAssumed Answered

To Join Table or not to Join Table

Question asked by EdwardMcgee on Mar 15, 2014
Latest reply on Mar 15, 2014 by philmodjunk

Title

To Join Table or not to Join Table

Post

     Grettings! I learn a lot here.

     Using FM Pro 12 on iMac OSX Mavericks

     My database is of an art collection. I want a portal to show me the titles bought from a certain dealer, but cannot get it to work. It looks like there is a relationship issue. Have I used the wrong table as the join table? Should it be TITLE>---DEALER---<ACQUISITION? Or should I use a join table at all?

      

Screen_Shot_2014-03-15_at_2.04.12_PM.png

Outcomes