AnsweredAssumed Answered

several portals in list view

Question asked by nicolasvallin on May 30, 2013
Latest reply on May 30, 2013 by nicolasvallin

Title

several portals in list view

Post

     Hi everybody!

     I am using filemaker pro 2012 and I am struggeling a little...

     I have 2 tables:

     The table box that has 2 fields (id1, which is unique and created automatically by filemaker when I create a reccord, and box#)

     The table item that has 2 fields as well (id2, unique with the same system as id1 and a boxID)

     The boxID points to id1.

     In a box, I can have several items but an item has to be in a single box...

     I want to display, in a list view of the box table, one portal per box. Each portal displaying all the items that are in this box.

     For example, if I have 4 box, I will display 4 portals and each portal will show all the items in the box.

     I used "=" between id1 and boxID in the relationship and "If ( Item::boxID = Box::id1 ; 1 ; 0 )" as the filter for the portal.

     The problem is that I only see one reccord in every portal even if I have several items...

Is there anything I did wrong?

      

     Any help will be appreciated!!!

      

     Nicolas

      

Outcomes