You need to set up a rule that every STATE.Country_Abbr must match an existing record in the COUNTRY table