1 of 1 people found this helpful
what you need is an additional relationship to Table B from A which 'filters the values based on a calculated field in B that both the parent and child values exist in.
Thank you. I think i get what your saying and i will implement it and let you know the outcome. Thank you again.