Table 1 is "Teams." The primary key is "ID", an integer.
Table 2 is "Members." The one-to-many join field is "EntityID," also an integer.
I have a ComboBox that helps to look up a particular "Team." A FormViewer on the Screen shows various details for the "Team." For testing, I have included a datacard (DataCard25) showing the "Team" ID.
I want the Screen to show "Members" (in a table format) that are associated with the selected Team.
I have tried a couple of different approaches, using both a 'DataTable' and using a 'Gallery', to display the filtered data. I've attempted a number of filtering formulas. I receive notices that my formula is incorrect or delegation warnings...
Filter('[dbo].[Members SubTable]', DataCardValue25.Text in Text(EntityID)) --Delegation
Hi @Bubba I'm sorry to hear you're experiencing this issue. User @tchin-nin has a new blog post up with a deep dive into Delegation. I am going to include the link below. If this does not help please reply in this thread so I can find you a better solution.