2 Replies Latest reply on Jan 20, 2010 3:52 AM by user21370

    Calculation: Get records related table

    user21370

      Title

      Calculation: Get records related table

      Post

      Hello,

       

      I have 2 tables: Crew and Vacations which are related through ID Crew.

      In the Vacations table crew can make records where they can plan there vacations:

      rec1   20-01-2010  (ID Crew) 001

      rec2   29-01-2010  (ID Crew) 010

       

      rec3   01-02-2010  (ID Crew) 001

      rec4   20-01-2010  (ID Crew) 009

       

      In the Crew Layout I can put a portal where I can see the Vacation dates of each crew member.

       

      But for calculation reasons I need a calculation field which shows me the dates in one field.

      Example for ID Crew 001:

      20-01-2010

      01-02-2010

       

      Can someone help me with the calculation?

       

      Thank you very much!