AnsweredAssumed Answered

Show All from Table 1 and related values from table 2

Question asked by andrewcs on Jan 19, 2015
Latest reply on Jan 19, 2015 by philmodjunk

Title

Show All from Table 1 and related values from table 2

Post

Greetings All. This has me stumped please help! I apologize if I have missed a thread that covers this.

Desired Output:

         
  • A portal view that shows everyone who belongs to a specific group (TO "Assignment Call Priority") along with a count of the number of "Calls" (work assignments) for a particular day using a calculated field st to Get(RecordNumber) in TO "Assignment Session".
  •      
  • You will see on the screen shot - I have this but...

Issue

         
  • Once a person has a record created for them in the "Assignment Session" TO they fall of of the portal when the user moves to the next "Assignment Session"

If I was doing SQL I would write an outer join. How can I get to the same result with FMP? Thanks All!

Capture_2015_01_19_141.PNG

Outcomes