I have a customer table and a sales tax table. The state code in the sales tax table is the primary key that is tied to the state in the customer table. I added a state code (CA) to the table and saved it. When I open up the sales tax table and click on the drop-down arrow and select 'OH', I get an error message: "Column "Tax State" is constrained to be unique; value 'OH' is already present. Why am I getting this error?
Visual Basic.net unique constraint because value already present?
- Thread starter cfljava
- Start date