[computerman29642]

Originally Posted by 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.

I will get started on this. Thanks.

[computerman29642]

I believe I have something really wrong. I tried to place the subform on the frmAddMovie form with the subform linked to the tblMovieStar table (Junction Table). However, no values are present in the combo box on the subform.

I have a StarringID in three different places. It is found in the tblStarring table, tblMovie table, and tblMovieStar table. Do I need all three?

[OBP]

I haven't seen your latest creation, but I would think it shouldn't be in the Movie table, the Link should be form the Movietable (MovieID) to the Junction table and from the Starring table (StarringID) to the Juction table.

[computerman29642]

I deleted the StarringID from the tblMovie Table. I believe something is still really screwed up. I have attached a copy of the database. I would really appreciate you taking a look.

[OBP]

You are correct, it is well screwed up
One major problem that you have is the form that you are using does not assign a value to the MovieID autonumber until you have clicked the "Add" button, which means that you although you can assign a Master/Child Link between the Main and Sub forms using the MovieID, there is nothing there for the Subform to Pick up on.
So I have corrected the data source for the Subform, added the Actual fields from the table to mainform for the MovieID and Movie Title, linked the 2 forms and it is now working.
But your Tabbed "Movies" form isn't

PS I like the String conversion using Propercase.

[computerman29642]

LOL....I had a feeling that I played with it too much. I appreciate you taking the time to correct the mistakes.

I will work on getting the tabbed "Movies" form working.

PS I like the String conversion using Propercase.

I guess you felt like a positive statement needed to be thrown in somewhere....LOL!

[OBP]

No, I actually hadn't seen that fuction used before, so I learnt something new, as I am always doing helping others.

[computerman29642]

I am glad that I was able to actually show you something.

I have the CategoryID and RatingID in the Movie Table, do they need to be deleted? There is a way to have all the stars display on the Movie form without showing duplicate records...correct?

[OBP]

No you need those IDs in the table to refer to the 2 tables.
I am not sure that I understand your question about Duplicate Stars, do you have some?

[computerman29642]

The Movie form is not duplicating the Stars. When a movie has more than one Star, all of the data is being duplicated in the subform of the Movie form. I was just making sure that was something I could stop from happening.

Would it be better to have the Stars showup in a Listbox?

[OBP]

You can, as you appear to like List boxes, but personally I prefer Subforms.

[computerman29642]

I do not mind using subforms, but I would like for the data not to duplicate.

[OBP]

Preventing duplication is not quite so straightforward as normal as this is a many to many table.
One way to achieve it would be to have another field that combines the MovieID and StarID and then set it's property to Indexed No Duplicates.

[computerman29642]

I will see if I can create the new field that will combine the data. I personally believe it would look better. What do you think?

[OBP]

I am not sure about the "look" of it, I usely just do "Function"