How to call field from other entity to grid of another entity RRS feed

  • Question

  • I have 3 - Entity

    1. Product

            - ProductName

            - ProductCode

            - MRP

            - Cost Price

    2. ProductPricing

            - OldPrice

            - CostPrice

            - NewPrice

    3. Units

            - UnitName

    Entity Relationships are

    (One) Units - (Many) Product

    (Many) ProductPricing - (One) Product

    I have designed a screen called "Bulk Product Pricing" and from "add data item" added query entity "productPricing". I have dragged the grid to the screen designer.

    But Now I need the "UnitName" from Entity "Units" including all the fields of Entity "ProductPricing".

    Confused now, how to do it. Please help

    Tashu Jacob ** Honesty is my sincerity **

    Friday, November 1, 2013 9:16 AM


  • Hi Tashu,

    You will have to add one field in the screen designer by clicking in the "Add data from another screen"

    Likely, UnitName will appear as (Product.Units.UnitName)

    Let me know for further queries.

    Mahen CEO - Private

    • Marked as answer by TashuJacob Saturday, November 2, 2013 3:37 AM
    Saturday, November 2, 2013 3:29 AM