Associate
Just wondering if a resident Sharepoint guru can help me out here.
I have been tasked with moving an old Access database into Sharepoint 2013 lists. The front-end to this 'database' will still be Access (2016).
I've managed to figure out most of the pitfalls (columns names and relationships mainly); however i'm stuck with how to create unique constraints on multiple list columns.
From some googling it seems that Sharepoint only supports uniqueness in single columns. Short of having the front-end run checks on everything before submitting the data to the back end; is there a simple way to have Sharepoint do a multi column check?
Hope that babbling makes sense to someone
I have been tasked with moving an old Access database into Sharepoint 2013 lists. The front-end to this 'database' will still be Access (2016).
I've managed to figure out most of the pitfalls (columns names and relationships mainly); however i'm stuck with how to create unique constraints on multiple list columns.
From some googling it seems that Sharepoint only supports uniqueness in single columns. Short of having the front-end run checks on everything before submitting the data to the back end; is there a simple way to have Sharepoint do a multi column check?
Hope that babbling makes sense to someone
