[jimr381]

Aye I would organize it as a many to many relationship since it should feasibly be setup like I said before.
I see you have other forms. Are you planning on making a switchboard to access these or just using the database window?

[gamecockfan]

I have not decided on the switchboard. I have thought about creating one, but I have not made my mind up yet. What do you think?

I will change the relationship to Many-To-Many. I still have not figured out how you all were talking about setting up the frmAddMovie form to select more than one star.

[jimr381]

I think OBP was talking about the form. Isn't it ya'll down there instead of you all?

[gamecockfan]

LOL....Well, I guess that would be a true statement. Every now and then we can speak with proper grammar down here.

The correct way to setup a Many-to-Many relationship would be through a junction table...right?

[jimr381]

Aye it would utilize a junction. I am from VA and that is supposed to be a southern state as well.

[gamecockfan]

I will create the junction table and relationship(s), and then repost the db. I want to be sure it is done correctly.

LOL....Why you given me a hard time then?

[gamecockfan]

I have created the junction table (tblMovieStar). Please take a look at the relationship(s), and let me know if I now have a Many-To-Many relationship established.

[gamecockfan]

How do youknow if a Many-To-Many relationship has been established?

[jimr381]

There is not really something called a many-to-many relationship when you examine the relationship via the window. You just know that you have two one-to-many relationships that are hitting a junction table.

[gamecockfan]

When I tested the junction table by creating a new movie, no data goes into the junction table.

[gamecockfan]

By chance did you happen to take a look at the attached dataabase?

[jimr381]

The cast should be setup in a subform, so that you can select multiple cast members for the movie. This subform will reference the junction table. I would setup the fields in the junction table as a drop-down list that references the star table.

[gamecockfan]

I will work on getting that done. Thanks.

[gamecockfan]

The subform would be added to the frmAddMovie form...correct?

[jimr381]

Aye. I was still adding information to my previous post when a client asked a question, so you might want to reread it. You also are missing X as a rating for the movies as well, unless you do not loan those out.