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…
@Tom_Roberson here’s one method:
Create table1 with primary field test name
Add field to table1. Field type link with record. Add table2 to link field name ‘assign teams’. Enable multiple records.
Try it and let me know.
Multi select is an inefficient way to proceed.
Cheers Neil.