you can try exist join on datasource property. i think it work for you. On Thu, Mar 13, 2008 at 2:53 PM, prosenjit ganguly <[EMAIL PROTECTED]> wrote:
> Dear All, > This is Prosenjit Ganguly new in AX.I am facing a problem which is > described below. > > I have created two table say TestHeader and TestLine.Primary key for > TestHeader is TestId. > and Primary key for TestLine is TestId and Line Num.An EDT is also created > against TestId field called *TestId*.I have created a normal relation in > that EDT against table TestHeader.So that it looks like TestId= > TestHeader.TestId. > > Now I have created a Form for taking two datasource ,TestHeader and > TestLine so that in that form we can display the related data of both of the > tables.It means for a TestId 101 record containing TestId 101 in TestLine > will be displayed.I have set Joinsource property of TestLine Datasource > TestHeader.But When I run the form all records in TestLine are displayed > irrespective of related TestID in TestHeader. > > I assume ,I am missing something in the Form Property Level. > > Please guide me. > > Prosenjit > > > > > > ------------------------------ > Looking for last minute shopping deals? Find them fast with Yahoo! > Search.<http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping> > > > -- Thanks & Regards Rahul Shah Sonata Software Limited Phone : +91 40 27782000 Xn 5019 Mobile : +91 09912228382 www.sonata-software.com Please don't print this email unless you really need to. This will help preserve trees on our planet.