What I would like to know is if there is any way to take a standard one to many relationship and then displaying only 1 for each related item. For instance, say i have a table:
Exceptions:
ExceptionID <-- Primary Key
LoanID <-- Foreign Key
ItemID <-- Foreign Key
Instead of in a query showing:
ExceptionID LoanID ItemID
1 204 1
2 204 2
3 204 4
4 500 1
5 500 6
6 600 8
7 999 2
I would like to see
LoanID ItemIDConcat (New Field in Query)
204 1, 2, 4
500 1, 6
600 8
999 2
If anyone has any suggestions, I would appreciate it. Thank you.
Exceptions:
ExceptionID <-- Primary Key
LoanID <-- Foreign Key
ItemID <-- Foreign Key
Instead of in a query showing:
ExceptionID LoanID ItemID
1 204 1
2 204 2
3 204 4
4 500 1
5 500 6
6 600 8
7 999 2
I would like to see
LoanID ItemIDConcat (New Field in Query)
204 1, 2, 4
500 1, 6
600 8
999 2
If anyone has any suggestions, I would appreciate it. Thank you.