But we might encounter a small issue. We'll have to remember the artist IDs of all artists. This is because the only artist information on the form is the ArtistId. The artists' names are nowhere to be seen.
This means we'll need to enter the artist ID for every album we enter.
This could become an inconvenience. Whenever we enter a new album, unless we remember the ID of every artist, we'll probably need to open up the Artists table to look up the ArtistId for the album we're entering.
Time for a slight redesign of the form.
Add a Combo Box with the Artists' Names
Here, we will add a combo box containing a list of all artists' names to the form. This will allow users to select artists by their name, rather than their ID. However, the form will still insert the ID into the Albums.ArtistId field.
Delete the old Control
Test the Form/Combo Box
Go ahead and use the form to add new records to the database — now's your chance to add something from the last 25 years ;).