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
Without knowing more, I would say SP will work. Â I can’t tell you how much an issue you will have with lists relationships until I know more details. Â I would think it would not be a real issue, since SP lists are basically databases/tables. Â There’s a lot that can be done with workflows.
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Â
Can you provide some examples of what you’re trying to do?
