CODEWITHSUNDEEP
lightswitch-2013
honey
honey

Reputation: 1

Lightswitch filter with multiple tables

I am using lightswitch and I have a "Grid" with table A. Table A related to Table B and table b related to table C. Now how do I access data from table c using Grid's PreprocessQuery or filter?

Upvotes: 0

Views: 361

Answers (1)

embedded.kyle
embedded.kyle

Reputation: 11466

You can expand each relationship in the query designer. Below I am creating a filter in the query designer on my QuoteLines table which has a relationship to my Quotes table which has a relationship to my RepFirms table which has a relationship to my InsideSalesReps table. You can filter on any data that is related to any of the linked tables.

query designer

Upvotes: 1

Related Questions