Forum Discussion
azelmas
Nov 07, 2020Copper Contributor
Managed Metadata for Customer and Project List
Hi, we want to store our project and customer documents on SharePoint online. We want to create lists for the customer and project lists, also use those values on document management. Structure will ...
Eva Vogel
Nov 07, 2020Steel Contributor
Hi azelmas, as a formefr Access Database architect I recommend Solution 2. "Customers" for me are one entity as well as another entity with the Projects. Projects are not just another Property or each Customer. One Customer can have multiple Projects with us, this will be on my mind. But from the perspective of Dynamics 365 Solution 1 is also an option, beyond 1:n relationships.
Hope this helps, Greets, Eva.