Alternate States One state updates the other, but not the other way.
I have a requirements for two tables. All of the values in table 1(State1) should apply to table two(State2), but any filters in table two(State2) should not affect table 1(State1).
I have attached a document. I tried to get this to work, but I have been unable to make changes to State2 once I implemented the trigger.
Doing this with triggers is a hard way to go. I sounds like you want State2 objects to honor selections from both States2 and State1. The cleanest way to do that is use set expression in your State2 objects that includes both states:
Doing this with triggers is a hard way to go. I sounds like you want State2 objects to honor selections from both States2 and State1. The cleanest way to do that is use set expression in your State2 objects that includes both states:
