OK Terry
Between diapers and burping the kid I reproduced your cheesy RIO app in .NET.
I also fixed the flaws in the database design. I really hope this wasn't a resume app for you.
I also spent the time doing my best to fix the UI and all the inconsistencies in RIO app's UI. The whole hot tracking deal is not a very good UI concept IMO.
However, the .NET version data keeps up fine with yours interms of querying local data.
The whole UI in general is problematic. And this from someone who claims o be a UI pro. Hmmm.
I added an add button as well seeing how you forgot to add that feature.
You can find this code at
www.dashpoint.com in the downloads section.
You will need to change the connedtion string in the library.vb file to corresponnd to your server.
Have Fun,
Rodman
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.