Lightswitch grid with complicated relationship?

I think that in this post is described exactly what you want to achieve: how to create a many to many relationship.

Up vote 1 down vote favorite share g+ share fb share tw.

I have setup a database to catalouge books .. the database format involves having a table for Books, a table for authors, and a link table between the two, with bookid, and authorid, so each book can have multiple authors. In Lightswitch I set up a datagrid to view by books table as usual, and there is the ability to add the authors in too (see screenshot as too hard to explain in text, but you hopefully know what I mean) .. but what happens is, in the grid the authors column is populated the same value for the author of the row that is selected at any time and obviously I want it to show the author for the book in that row. Where am I going wrong?

There are no options I can see to change the binding, but I am new to LightSwitch. Thanks! Visual-studio-lightswitch link|improve this question asked Feb 29 at 13:34user1012525203.

Thank you, yes that is very helpful! – user1012525 Mar 1 at 10:13.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.