My Procurement Unit consists of 3 Major Team:
Team A: Processors (20 staff)
Team B: Buyers (10 staff)
Team C: Shipping (10 staff)
Each team created their own separate Sharepoint List, each lists have up to 50 unique columns .
There is a need to share information across all 3 teams, with the common shared data being "PO number".
We are also thinking of GUI to perform imputs, rather than using the List.
Also, having data from three teams, we can have an overview of each transaction and perform calculations + measure KPI.
What is the best solution for this?
Appreciate anyone's advice, thank you!
Go to Solution.
MS Acces (AWA) is dead, it was great but will be dropped soon.
Use Azure SQL Database, it will be a great learning experience and you will be able to do lots.
View solution in original post
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand