thnx john for replying

But the 2 tables do not have a common relationship. however i have resolved this problem by modifying the query of tjhe main dataset.

still is it possible...