Primary Keys on the Database

Primary Keys on the Database

  
Is there a  way to drop the ID AutoIncrement and define a different primary key?

So here is mny issue.  I have two tables with data and we use CASE_ID to tie these tables together.  When I cretae the new data entities I get the ID auto increment primary key.  I want to remove that primary key and define the primary key using CASE_ID.

Thanks 

John
Hi John,

As far as I can understand, what you want to create is a one to one relationship between the two tables. You can read this article from the documentation to learn how to do it.

Does it help you?
Antonio,

Yes this does help some.  I have added an index on the attribute CASE_ID on my tables.  Now I need to create a relationship between these tables using the CASE_ID index.

Thanks

John