Please I need help with combobox

[em12]

OK I can't find the way to do this and I would really appreciate some help.

for example:

COMPANY is join to MOVIES (one company to many movies)

now since 2 movies can have to same name but made by different company...



for my other table MOVIES_PRODUCTION( many movies to many production)
instead of writing the movie id in the MOVIES_PRODUCTION table...

i would like to have a dropdown list that would say the movie name and the company.

I can get the movie name but i cant get the company beside it i just get its id number (idcompany that is in the MOVIE table)

oh and all my ids are autonumbers... they dont mean anything that why i would like to see the names instead.

Please.. any help would be very appreciated

[jzwp11]

Welcome to the forum!


It sounds like your tables are structured as follows which appear to be correct

Company
-CompanyID primary key, autonumber
-CompanyName

Movies
-MovieID primary key, autonumber
-MovieName

MOVIES_PRODUCTION
-MovieProductionID primary key, autonubmer
-MovieID foreign key to Movies table
-CompanyID foreign key to Company table

First, are the dropdowns you are referring to at the table level or in a form? If they are at the table level, that is not recommended; see this link for more information. Dropdowns (combo boxes) are OK when used in forms. In other words, you would not have the movie and company names in Movies_Production only the ID fields. To make it easier to view, you would use forms.

I'm not sure if you want to see the movies and the companies that produced them or the other way around. I assume you are interested in seeing the movies, so I would base a main form on the movies table and then use a subform based on the Movies_Production table. In that subform, you would use a combo box (dropdown) to display the companies that have made the movie shown in the main form.