Jack - Many thanks to you, the query worked great.

Note: As I stated, I am using student/parent tbls scenario as an example. Once again, thanks.