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.
Ron Seidl
Independent Developer
VFP
"I'm playing in life's theater in anticipation of a great cast party!"