Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filtering a '1' table based on a 'many' table
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00122509
Message ID:
00122786
Views:
18
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform