Here’s what I’m trying to accomplish:
Table 1 contains test cases. The primary field is the test name. Each test has a multiple select for team(s) assigned to run the test (team1 and team2, for the sake of example).
I want table 2 to automatically populate records from Table 1, but those records should only be ones where the assigned team is “team2.”
Currently I’m manually copy/pasting records from Table 1 to Table 2, but there MUST be an easier way…