General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only