Re: Help With File Size Limitations - Large Flat Files

Con, Thanks for your reply! ---------------------------------------------------------------------------- Cory Sandahl Systems Programmer/Analyst Harborview Medical Center 223-5425 or sandahl@u.washington.edu ---------------------------------------------------------------------------- On Mon, 9 Jan 1995, Con Woodall wrote: } } } On Wed, 4 Jan 1995, Cory Sandahl wrote: } } > } > Fellow DBAs: } > } Stuff left out } > PROBLEM: } > I work with a group of 15 interpreters who are using the Psion 3a } > palmtop computer to store information on patients that they visit in the } > community. On a weekly basis I transfer this information from the } > palmtops into MS Access to print reports for our directors. Because it } > wasn't possible to setup a one-to-many relationship with the DB supplied } > on the Psion, I was forced to design the records flat. Each record } > consists of patient name, address, other miscellaneous contact } > information along with a series of contact dates and descriptions (see } > below): } > } Cory, } I don't know anything about how you program the Psion 3a, but, as long } as you are reading flat and parsing anyway, it would seem you could } accept multiple records per patient. Presumably they would be } keyed by patient id anyway. } Good luck } -- } Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; } cwoodall@vth1.vth.colostate.edu } }