带有多个表的电灯过滤器 [英] Lightswitch filter with multiple tables

问题描述

我正在使用lightswitch，并且具有与表A相关的网格".表A与表B相关，表b与表C相关.现在如何使用网格的PreprocessQuery或过滤器访问表c中的数据?

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?

推荐答案

您可以在查询设计器中扩展每个关系.下面，我在查询设计器中的QuoteLines表上创建一个过滤器，该过滤器与我的Quotes表有关系，而我的Quotes表又与我的RepFirms表有关系，而我的RepFirms表又与我的InsideSalesReps表有关系.您可以过滤与任何链接表相关的任何数据.

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.

这篇关于带有多个表的电灯过滤器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！