Generate PalmOS searchable file from Access DB using VB6 code.

I'm looking for a VB6 procedure that, with a click of a button, will create a palm OS file that contains some information from an Access2000 database. Please see the attached example of the database I'll be using with a few demo fields. The procedure will be added to a large VB program, and preferably it will use Dlls and OCXs included in the basic VB program and avoid classes and other more complicated VB programing issues. While I'm not sure how easy or hard it will be to do this to Palm and PDA OS's, nor do I understand what application a palm must be running to display this sort of hierarchical data, I'm looking for the following: At a minimum, one needs to be able to Pull a patient and some demographic information (Last name, First name, birthdate, address, city, state, zip, phone, pharmacy number) all contained in the Patient table within the database. Pulling a patient would be done by searching the first letters of a patients last name. Additional features required is the following information for the specificed patient found in the associated tables. For example, a list of the patient's Problems (from ListPROBLEMS table) and the patient's Medications (from ListMEDS). Finally, if the Palm OS could also display the patients Last Note (from SOAP), this would be the icing on the cake! Let me know how doable this is, and what program a Palm OS user would need to have this capability (preferable something that comes with Palm). Giving the option to output the handheld file for different PDA OS (casio, windows CE, etc) would be even more amazing. ## Deliverables Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.