我正在使用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.
更多推荐
带有多个表的电灯过滤器
发布评论