Basic problem: Need to set primary key to auto value = yes.
Removed all relationships for that table. Also removed all joins in queries.
Still would not save due to constraint.
Ran system constraint query which shows the table with a Primary key, and Foreign Key constraint even after all was removed.
Attempted to execute: ALTER TABLE “VENDOR MASTER TABLE 20230203” ALTER COLUMN “ID” INT IDENTITY
Result = Table not found
then I ran the query for system tables which also shows the table is there.
So how do I fix a table when the alter table command can’t find it?
Just updated to 7.4.5.1 two days ago
Just in case this makes a difference: I saved the relationships and edited queries but not the database.
********Turns out there was a teeny tiny little dot next to the Primary ID which had set a relationship from ID to ID as a Foreign Key. So, the table showed up twice under constraints. Once I deleted that, it’s ok.