I usually work with SharePoint as my datasource but for this piece of work, I am experimenting with Dataverse primarily because of the ability to create relationships with the data. However, I am finding it a little tricky to think how best to structure the tables/relationships.
Essentially my users need to start by selecting a project. For each project, there is a type of shopping list of items which will always be the same. However, for each item, there are further characteristics that need to be defined. The user needs to input this information. That list is then sent to another team who create another revision. Further revisions are made until the list is finalised.
I want all the project data to be in the same environment. I am going to use a canvas app for the selection and input. So far I have a Projects table and a table with the 'Shopping list' and characteristics. But essentially that shopping list will need to be duplicated when a project is created. Any advice on how best to do this is appreciated.
