I have two tables... competitor_tbl and old_competitor_tbl. When I input data into the competitor_tbl I want the field ssn to check my old_competitor_tbl to see if the inputted ssn is in the old_competitor_tbl. If not return a value of new to a field called status in the competitor_tbl. Any thoughts would be helpful.
Thanks,
Wayne
Thanks,
Wayne