Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Filtering a '1' table based on a 'many' table
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00122509
Message ID:
00122786
Vues:
17
Diana,

I'd use several views, basically one for each underlying child table. Assuming the child tables all have say iClientKey as their foreign keys into client you just set the filter tab in the view designer to EmergencyVisit.iClientKey = ?client.iPrimaryKeyField

Whenever the value controlling the subset of the view changes you TableUpdate() it to save changes and then Requery( "EmergencyVisitView" )

>I think that makes sense. However, I have very little experience with parameterized views and am wondering how I'm going to set up this view to change from all clients, to clients with rows in the emergency visit table to clients with rows in the legal activity table and back to clients. Also, I'm assuming I can treat the view just like the client table in my database and set persistant relationships so the other pages work so conveniently...
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform