Author: amereto2k | Posted on: 11/18/2008 11:45:07 AM | Views : 265

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 ...