Hi
The tables below:
Customer Table
CustomerRef PK
.....
Order Table
OrderRef PK
CustomerRef FK
StaffRef FK
......
Staff Ref is the initials of the staff member that has been dealing with the customers order.
We have a report showing each customer and the quantity of orders made this year (using a suppressed list of orders). We need to add to the list a one line value showing in order the StaffRefs of the orders made, eg:
"CSD, SAS, BDF, CHD"
I am stumped on how I can do this, any help would be much appreciated.
Thanks
B
The tables below:
Customer Table
CustomerRef PK
.....
Order Table
OrderRef PK
CustomerRef FK
StaffRef FK
......
Staff Ref is the initials of the staff member that has been dealing with the customers order.
We have a report showing each customer and the quantity of orders made this year (using a suppressed list of orders). We need to add to the list a one line value showing in order the StaffRefs of the orders made, eg:
"CSD, SAS, BDF, CHD"
I am stumped on how I can do this, any help would be much appreciated.
Thanks
B