AnsweredAssumed Answered

How to combine values from a related table?

Question asked by mgrahamor on Oct 9, 2018
Latest reply on Oct 9, 2018 by mgrahamor

I have a table named “Orders” that looks like this in table view:

OrderNumber

OrderDate

Name

Address

1

10/8/2018

Bob

AnyTown

2

10/5/2018

Fred

SomePlace

 

And an “OrdersList” table, that uses the same OrderNumber key:

OrderNumber

ItemID

ItemCost

ItemName

1

W1

10

Widget 1

1

W2

8

Widget 2

1

T12

5

Thing 12

2

T7

3

Thing 7

 

I want to create a List View to show totals for each order:

OrderNumber

OrderDate

Name

TotalCost

ItemList

1

10/8/2018

Bob

23

W1,W2,T12

2

10/5/2018

Fred

3

T7

 

The first three columns are simple. The question is,  how do I get the values for TotalCost and ItemList? Are these calculated fields? SQL calls? I have tried a few different things, but not getting the results I want.

Outcomes