Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Setting Relations
Message
From
18/01/2000 17:33:17
 
 
To
18/01/2000 17:18:09
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00319644
Message ID:
00319651
Views:
12
The direct answer to your question is that you have Patients and Laboratory indexed on Patient_id. You set a relationship from Centers to Patients on Patient_id and set another relationship from Patients to Laboratory also on Patient_id. Assuming each of those relationships is one-to-many, don't forget to set skip to the child tables from the parent tables. You can verify that you have it set correctly by browsing the three tables and moving the record pointer only in Centers.
My guess is you could save yourself a lot of trouble by using SELECT - SQL to create a cursor with all of the information you need and report directly from the cursor.
HTH

>I need to develop a report that lists the centers and all the patients that belong to that center along with their laboratory results. The report should pull the data from the following tables:
>
>Patients
>Centers
>Laboratory
>
>All contains a linked field: Patient_id
>
>How can I set relation to all three tables so that once finds all the patients in one center, it'll just move on to the next...
>
>TIA
>
>Jeff T.
Previous
Reply
Map
View

Click here to load this message in the networking platform