2 Replies Latest reply on Mar 9, 2011 1:58 PM by billcritten

    how to display data from joined tables?

    billcritten

      Title

      how to display data from joined tables?

      Post

      How can I base a layout on joine tables to display fields from both tables?

      Master
      ID  Fname   LName
      1   Joe        Smith
      2   Suzi       Jones


      Detail
      ID   Item   Quantity   Purchdate
      1      cup       5          1/1/09
      1      plate     5          2/1/09
      1      chair     5          3/1/09
      2      dress    3          2/15/09
      2      coat      1          2/27/09
      2      boots    1          3/15/09


      Display in layout
      Fname  Lname   Item   Quantiy  PurchDate
      Joe       Smith      cup     5            1/1/09
      Joe       Smith      plate   5             2/1/09
      Joe       Smith      chair   5            3/1/09

      Thanks