Foreign key relationship in sharepoint list?

Question

How can I implement foreign key relationship in a SharePoint list? I am not talking about lookup types but a typical foreign key relationship where in a column "ID_Keys" in a table is the primary key of "Keys" table. How can we force SharePoint to enforce integrity? Is it at all possible to design a true relational schema with SharePoint lists?

 

Thanks for sharing your thoughts!

Answer 1

so far sharepoint is not meant to be a RDBMS system. so we should not confuse it with such requirements.

if you have such a requirement, you will have to do it at your own by writing an Event handler so you can check this relationship.

Answer 2

A bit late, but still - the SPListConstraints feature for SharePoint contains, among other constraints, a foreign key constraints for SharePoint list.

The main difference, atleast at this time, from SQL foreign constraints is that the foreign constraint in SPListConstraints does not prevent removing records from the foreign list.

Answer 3

See List Relationships in SharePoint 2010