I have some tables in my database containing interviews with artists.
I have a table 'interview' that contains records with an artist id,
and a table 'interview_qa' that contains records with an interview id.

It would be very nice if my Access form worked such that a combo box
was populated with the names of the artists (I know how to do that
part) and that when an artist is selected, a list box is
populated with the interviews that artist has done (so SELECT blah
FROM interview WHERE artist_id=id_from_artist_combo_box). When an
interview has been selected, a datasheet should be populated with the
results of SELECT question, answer FROM interview_qa WHERE
interview_id=id_of_interview_from_list_box. That seems like an
intuitive way of editing this data.

But I do not understand how to get the id from the artist combo box,
or how to populate the interview list box with the right data when an
artist is selected.

I'm using Access 2003.

Hi carbon,

in form design view, select the combo box, press F4 to open
'properties', select 'Data' tab, go to 'Row Source' and click on '...'
button which appears to the right. It will open a query design window 
in which you can create a query which will return the necessary data.
When finished, simply try to close the query. When prompted with
something like "would you like to update query definition?", click
yes. You will be returned back to to the 'properties' in form design
mode with data source updated.

Cheers,