The database Movies.accdb has two tables named Lines and Actors. The Lines table contains famous lines from films that were spoken by the leading male actor. The first field of the table gives the famous line and the second field gives the film. The figure below shows the first three records of the Lines table.
The Actors table contains some names of films and their leading male actors. The figure below shows the first three records of the Actors table.
The “film” field in the Lines table is a foreign key to the “film” field in the Actors table. Use the Movies database to write a program that displays the names of films from the Actors table in a list box. When the user clicks on a film’s name, the famous lines from the Lines table that were spoken in that film should be displayed in a second list box. See the figure below.
Write a program that displays the name of the films from the Actors table in a list box. When the user clicks on a film’s name, the famous lines from the Lines table that were spoken in that film should be displayed in a second list box. See the figure below for an example.
Suggested Control Names and Attributes( without container ):
Name Property | Text Property | Control Type | Notes |
frmMovies | Famous Movie Lines | Form | Holds Controls |
lstMovies | ListBox | Displays list of movies | |
lstLines | ListBox | Displays list of lines |