Many To Many Relationship
Well I'm interested in Database programming using Visual Basic.Net
but I can't create a form in which controls like textboxes and comboboxes are bound to records from tables with many to many relationship.To make my point clearer I want to create a form to display a title record and all its authors.As you know the relationship between titles and authors are many to many where a title can be created by more than one author and of course the author can create more than one title.The problem lies in the intermediate table that links both tables (the authors table and the titles table).Shall I bind the controls to the intermediate table or to the authors and the intermediate table or to the three of them.Well it's a little bit messy for me.
I would be very grateful if you help me on this one giving an example to any many to many relationship.
samersult
|
