Say if I have a field called Status and I have a dropdown list attached to it called Order status. And in that order status list I have Won, Shipped, Canceled , and On Hold. Then I have two Tables Table 1 and Table 2. One one table I have two fields for ex.. Name_First, Name_Last, Table 2 Name_First_s, Name_Last_s..
I want to do an auto enter or script To where if the Status is Won Then the Name_First populate into the Name_First_s.. If that make sense..Which route would be the better or easier to accomplish.