locked
Add query or datagrid column from related table RRS feed

  • Question

  • Thanks for help on this,

    Looking at moving from Access and I'm impressed with the deployment possibilities of LS along with the RAD focus (great name too - Lightswitch).

    Struggling with something that I'm sure is simple but I'm missing - how do I add a column/field to a query or a datagrid from a related table in LS.  I've tried adding a Data Item in a screen, bit I can't add a field to the grid, and there doesn't seem to be any options to add fields in the query builder.

    What am I missing folks?

    Brad

    Tuesday, May 21, 2013 9:56 AM

Answers

  • Brad,

    On the node you want the field, choose Add >> Other Screen Data...  Select the related entity, press "." (period) and the list will display the fields of the related entity where you can then select the field.

    Hope this helps.


    Brian

    • Marked as answer by Brad Stevens Tuesday, May 21, 2013 4:36 PM
    Tuesday, May 21, 2013 1:55 PM

All replies

  • Brad,

    On the node you want the field, choose Add >> Other Screen Data...  Select the related entity, press "." (period) and the list will display the fields of the related entity where you can then select the field.

    Hope this helps.


    Brian

    • Marked as answer by Brad Stevens Tuesday, May 21, 2013 4:36 PM
    Tuesday, May 21, 2013 1:55 PM
  • Thanks Brian - appreciate the help on something simple.

    Tuesday, May 21, 2013 4:37 PM