Forum Discussion
How do you prevent SharePoint from resetting primary key numbers - Backend on Two sites must match
I have an MS Access 2016 database storing its back end on a SharePoint online site for one or our teams. Another team within our agency wants to use the same database for their site. I must uploa...
SharePoint will ONLY use its own Primary Keys for relationships between tables. And, to enforce Referential Integrity between lists (tables as they are linked in Access), SharePoint can only use the Lookup fields using its own Primary Keys. I don't know what those text based primary keys really are, but I doubt they are actually working as Primary Keys within the application,
I find the text IDs redundant. That database uses vba programming to update both the pkID (present in the TITLE field) and a secondary TxtID when changes are made or new items are created. I wanted to avoid this redundancy and tried to explain my concerns, but I was cut off in the conversation. Turns out I am not a very good communicator.
