I have two SQL tables, linked in a one-to-many relationship.
Table 1 is 'Teams.' The primary key is "ID," an integer.
Table 2 is 'Members.' The join field is "EntityID," also an integer.
I use a ComboBox to look up a particular "Team." A FormViewer on the screen shows various details about the "Team." I have included a datacard (DataCard20) which correctly displays the selected "Team" ID.
I want to display "Members" (in a table format) who are associated with the selected Team on the same screen.
I can hard code the filter and get expected results. For example,
Filter('[dbo].[Members]', EntityID = 1731), where '1731' is an actual "ID" from Teams.
However, my attempts at creating a filtering formula fail or generate warnings. Here are some of my attempts:
Filter('[dbo].[Members]', EntityID = DataCardValue25) (Errors with invalid argument)