Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Setting Relations
Message
De
18/01/2000 17:33:17
 
 
À
18/01/2000 17:18:09
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00319644
Message ID:
00319651
Vues:
11
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform