You are correct that it should work. If the field within the portal is too high then only one name will appear (in the top row). You might try moving the field(s) down to well within the portal lines.
Thanks for that reminder, but I have squeezed the fields in the portal enough so that they squeal! I've recreated the Employee portal from the Gate context several times with just one field.
It must be working right and telling me what it is set up to do, but just not what I expect of it.
Does the Gate table data remind anyone of anything?
Perhaps the join table data suggests a solution?
I still haven't figured out a solution to this problem.
You are displaying in table view? Portals don't work in table view and will always only display the first related record (first related record according to the relationship sort). Change to list or form view and your portal will work properly.
I also noticed ... your _fk_GateID isn't ever duplicated; in fact it's the same as the _pk_JoinID (maybe just coincidence). But a single Gate record (in the gates table) CAN'T display more than one person because, in your example data, there is not more than one person assigned to a Gate.
Create a join record with employeeID 2 and gateID 1 and see what your layout displays (but still it won't display portal in table view).
Thanks for your responses, LaRetta. They were very helpful.
I am displaying in form view with the portal, but was just showing the data above in the table.
I've rearranged my relationships so that the join table contains the correct IDs and it works now.