Need help with Portal in FileMaker Pro ver 7
I have four tables in the database with the following relationship: TableA -> TableB -> TableC <- TableD. The -> indicates one-to-many relationship while <- indicates many-to-one relationship.
When I create a portal with the TableC under TableD in the layout and the portal fields include related fields from Table B and Table A, everything woks fine. However, when I create a portal with TableC under TableA in the layout and include related fields from TableB and TableA, the portal output generates all the related records from TableC but value in the related fields from TableB and TableA only shows the first matched value. As I am new to FileMAker, I am obviously missing some trick here. Can someone help?