Hi,
I have a question regarding many to many database design.
I have an Actors table
Each actor can specify up to 3 films they appear in.
Actors can appear in the same film so i made the following
Actor Table
Film Table
ActorFilm Table
My question is in which of the three tables above do I put the columns to get the input from the actor such as Film1,Film2,Film3
I want to attach a gridview binded to an object data source and an insert method in the dal so the answers go into the approaprite database table.
I then want to display the actors name and films they specified in a bullet list on another aspx.page.
thanks for any help
...
Go to the complete details ...