Show All from Table 1 and related values from table 2
Greetings All. This has me stumped please help! I apologize if I have missed a thread that covers this.
- 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...
- 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!