I am working on developing a heart transplant database in our hospital's
department of surgery. I am using Foxpro2.6 for the Macintosh.
There are few patients in the database but there is a vast amount of data
for each patient. For example, we keep a
detailed medical history, demographic information, diagnostic
information, etc. Thus, we need to use our database a bit differently
from the usual way: instead of flipping around from record to record and
entering or viewing data, we need to enter or view several screens worth
of information for a single patient and we don't usually need to flip
through different patients' data at one time.
Right now, there are several dbf files with patient information. I want
to create one big screen set with which displays information from multiple
tables. Thus, in going from one screen to another, I need to be able to
locate the correct patient's record and display the information in a
screen. I can get Foxpro to go to the correct table and locate the
record, but it will not display the data in the new screen. Also, there
seems to be a limit of about six on the number of screens I can string
together in one set.
I would greatly appreciate any friendly advice you can give me.
Thanks in advance,
Alexandra Richards, Columbia-Presbyterian Department of Surgery.