Randy,
>Thanks Bob, this works fine. I just got back from Kevin's class and I am still learning where to put everything. By the way, I am now officially am member of "The Knights that say McNeish". :)>
I hope you haven't given away the secret Black Knight handshake!
Without knowing more details about your app and database layout, it's difficult to give you a complete solution, but it does sound a change at a different level would simplify things for you!
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com