I have 2 tables; table 1 and table 2. In table 2, I have 45 records of Names and there is a group tag that is either "1" or "2". I would like to have a drop-down that will show me only Names that have a value of "2" in the group field. I created a TO that has a relationship between a global field in Table 1 and the Group field in Table 2. I have the value list set up to show Names from Table 2 and Include only related values starting from: Table 1 (where the global value is).
If I enter a "2" in the field by hand, it shows the correct names. How can I have it change the global field to a 2 automatically when the drop-down is entered? I've tried a script that enters "2" into the global field when the drop-down is entered but that didn't work.
Thanks for any help you can give.