Creating a form with two datasources

tpriyan
tpriyan Member Posts: 32
edited 2008-01-17 in Dynamics AX
Hi
I created a grid in form with two datasources but the values from the second datasource are not populated properly. Can u tell me how i have to make these values properly. Also there's a relationship between the two datasources.

Thanks in advance

Comments

  • arijitbasu
    arijitbasu Member Posts: 19
    You need to select the Joins and the join types in the form datasource between the t datasources. For an eg. please see the Sales Table or PurchTable forms. :D
    Arijit Basu
    MVP - Microsoft Dynamics AX
    http://daxguy.blogspot.com/
  • tpriyan
    tpriyan Member Posts: 32
    HI,
    Thx for the reply. I used joins but i cannot select the field based on which a join is made. Can u let me know how to select a relation field in innerjoin.
    Thx a lot in advance
  • suyesh
    suyesh Member Posts: 12
    Hi,
    You have to define the relation in Table(AOT->DataDictionary).

    Expand your table and in relation node you can create a relation to the related table using Normal relation type.

    Then in form datasource you select join datasource.

    For reference See the Table "SalesLine" where relation is made with SalesTable with respect to salesId field.

    Then check SalesTable form.
    And see the property of SalesLine datasource.

    Try in same way.

    Rgds,
    Suyesh
  • tpriyan
    tpriyan Member Posts: 32
    Thanks a lot for ur reply
  • Vinoth_mct2003
    Vinoth_mct2003 Member Posts: 26
    check out the JoinSouce and linktype propertied of the datasource
    With Regards,
    Vinoth Kumar.J

Categories