We've had great success using Pendragon Forms v3.2 from Pendragon Software. It provides table design in Access, showing how the Palm screens will look. Then it creates the Access table while building the Palm app in the process. The Access table canbe linked to an existing SQL table, permitting data to flow from SQL to Palm, and back again during HotSync.
Pendragon supports lookup tables, daughter tables, and a scripting language that can do data validation, skip patterns, etc.
They providegood support, and the product itself is reasonably priced (particularly for a poor state facility!)
I tied to it a version of my generic report-writer .ASP program, using a meta-data report table in Access. With this combination I can design a datacollection table in Pendagon in half an hour, and in another half hour have standard data listing and counting reports designed, and my users can run the reports thru the web front end.