I have a DB with a table that contains fields for asset #, division and state. Each division works in up to 3 states. I am looking for a way to verify that the state field is valid for the division. For example, Div 21 works in NY, NJ and PA. Asset 10000 is assigned to Div 21 and I want to make sure the state field is either NY, NJ or PA. Any ideas?
Thanks for the help.