Hi, I was wondering if someone could please help me. I have an access database with two tables. One table is Movie and the other is Genre all in a relationship. I have a foreign key in Movie pointing to Genre. My Movie table looks like this "MovieID, MovieName, GenreFK". My Genre table looks like this "GenreID, GenreName". My problem is when I create an input form. I don't want the drop down box to show the FK number but instead the GenreName. And I submit The Movie table should have the right number on the FK. I hope this makes sense please please can someone help me.
mundetas
0
Light Poster
Recommended Answers
Jump to PostOk, first i imagine you have a dropdownlist to display all genres in the new movie entry form. is that is the case you will have a select statment like.
select GenreID, GenreName from Genre
then fill a dataset with that result, lets say the dataset is called dsGenres …
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.