Re: Help With File Size Limitations - Large Flat Files

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