I see where you may find PDAs confusing. The one thing you have to forget is it's not a PC. Even the PocketPC PDA has little in common with how you write software for a PC.

Let me share how I solved a similar app. We used the free PODS (PalmSource's development kit for PalmOS) to write a program to collect the data then used a small application on the PC side to sync the data to the SQL database.

Worked fine.

If the information is dynamic, that's handled with ... more code.

What some expected was an easy button to get from PC to PDA. If you find it, do share it.