Hi
I have been assigned the task to create a SharePoint Online based “Systems Catalogue” which will contain a lot of lists that are related to each other (eg. Systems, Servers, Costumers, Roles, IP-adresses etc).
As I see it, I have three possible ways to do this:
- Pure SharePoint
- Access Web App
- BCS
Some of the main issues with these three solutions are:
- Pure SharePoint will give me a lot problems regarding relations between lists.
- Access Web App doesn’t support many-to-many relations.
- BCS doesn’t support workflows.
So I am having a hard time deciding which solution to choose – or if I should advice against SharePoint all together.
I need some advice. Which solution would be best seen from the users point of view and which would be the easiest to maintain.
Thanks
Jakob
Hi Keith
No, not at this point. What I am trying to find out is which solution will be the best to choose, if I want it to be flexible, user friendly and easy to maintain and expand.
I have experience with solutions 1 and 2, but I don’t know if solution 3 is any good in a situation were I have multiple tables with relations between them. Can I for instance have an external table on SharePoint that has a lookup in another external table?
/JakobÂ
