Forum Discussion
ca2511
Oct 01, 2021Copper Contributor
creating a relationship between two sharepoint lists in access
I have a database I've built for our student admissions information. Due to us all working from home and not being able to share data over LAN I have put the tables in sharepoint. I have two tables, ...
George_Hepworth
Oct 01, 2021Silver Contributor
Yes, you can enforce referential integrity on SharePoint lists, but you have to do it on the SharePoint side.
The mechanism to do that is the Lookup Field! Honestly, that's the only case in which I would use Lookup Fields, but because it's the way you have to enforce RI on SharePoint lists, it's what you have to do.
The problem, of course, is that you can't convert your existing Foreign Key fields to Lookups in SharePoint, you have to add the Lookup field and use that as the new Foreign Key, being careful to update existing values appropriately.