Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set filter
Message
From
22/08/2002 16:28:46
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00692644
Message ID:
00692659
Views:
11
Since you applied the filter to age<10 to the main table the related table will only give you related records. Thus, imposing filter into table B

>I have a question about setting filters.
>
>TableA :
>Fields are -
>ID
>Name
>Age
>
>TableB :
>Fields are -
>ID
>Height
>
>I want to retrieve all records where Age < 10.
>
>Use TableA in 0 order ID
>Use TableB in 0 order ID
>select TableA
>set relation to ID into TableB additive
>set filter to age < 10
>
>How do I ensure that this filter is imposed on tableB as well?
>
>Thank you.
>
>Ria
Previous
Reply
Map
View

Click here to load this message in the networking platform