Populating Drop down box on input table

[penguinspeaks]

I have 3 tables in my access DB with the fields shown:

Albums
ALB_ID
ALB_Name
ALB_ArtistId

Artist
ART_ID
ART_Name

Song
SNG_Name
SNG_ArtistId
SNG_AlbumId

I need to make a form that has a field to enter the album name and a field that displays the ART_Name. When the ART_Name is chosen, the input is the ART_ID from that table. So the result would be an entry in the Album table with the Album name and the Artists ID from the other table.

I have been using online forms and databases for so long that I do not remember how to use access. I have tried to search this, but either it is not what I want or I am missing something.

Any help would be appreciated.

 

[dhookom]

Create a form with a Record Source of the Albums table. Use a combo box to select the artist:
[tt]
Name: cboArtistID
Control Source: ALB_ArtistID
Row Source: SELECT ART_ID, ART_Name FROM Artist ORDER BY 2;
Column Count: 2
Bound Column: 1
Column Widths: 0,1
[/tt]

Duane
Hook'D on Access
MS Access MVP

 

[penguinspeaks]

I will try this Thanks so much!