Posted on 2013-06-13
I have 2 tables with the following setup
Table 2's Auto ID is a unique reference, users add comments for Table 2 into Table 1 and they are linked via Auto ID - Reference.
I now have a view on sharepoint and I want to be able to show all the comments for Table 2's record in 1 column, how is the easiest way I can go about doing this please?
I am using SQL 2008 Express.