I am presently brain dead...

I have a simple form having two tables with a parent child relationship. I want to select a record from the parent, and have the list box refresh with the info from the child. Brain is mush and can't get it right.

If I use a SQL statement to fill the rowsource, clicking on the result row won't give me the child record number (or will it?) and, when I do this, I get a SQL select result each time I refresh.

If I use Alias as the row source type, I can't seem to find out how to filter the display to only the appropriate child records.

Please help.