AnsweredAssumed Answered

how to display data from joined tables?

Question asked by billcritten on Mar 9, 2011
Latest reply on Mar 9, 2011 by 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

Outcomes