This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have built a database using Access which has several junction tables. When I try to export those tables to SharePoint, I get the following message (see below). The data types in all of my junction tables are 'Number' relating to the primary key of it's separate related table (see image below). Do I need to do anything differently to export these to SharePoint or is it not possible?
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
You have composite keys. Add an Autonumber PK to your junction tables and put a unique multi-field index on the combination of FKs. Then export.
In addition to what Scott indicated, you should also be aware that SharePoint requires the use of Lookup fields to enforce referential integrity on related tables. I do not think they are created automatically when you export the tables to SharePoint lists unless you have already defined them in the Access table. This is the only time I would recommend using Lookup fields in tables in Access.
Hoping that I understand you correctly as I've not done this before, is this what it should look like?
In addition, I just noticed that when I export to SharePoint, multiple list of the same table are being created (e.g., Consumer, Consumer_1, Consumer_2, etc.). Should this happen or have I set things up incorrectly.
Probably not. But we can't see how you exported the tables, unfortunately.
Did you implement the Lookup Fields as suggested?