Late last night I got what I was after by using a Stored procedure. The input parameters made it a little more flexible than what I originally intended. Coming from MS Access, Stored Procedures are not the first thing that comes to mind. That's beginning to change. I'm beginning to really love Firebird.

Thanks for the suggestions. I will keep those strategies in mind for the future. I really appreciate the help.