Dynamic work orders

[Nass_]

Hi all

I have a question in creating my dataverse model:

Scenario:

We have a Backoffice (model driven app) and a mobile app for the technicians.

In dataverse we have an inventory of clients, items, locations, and work orders

The Backoffice needs to create work orders for each day, for the technicians (these are different for each client).

However, when the technician comments that a new item needs to be added to the work order, the Backoffice will need to add certain items to that work order, so the next inspection, the work order is updated with the new information.

This may look like a dumb question but I am a little lost here.

How can I facilitate the data model so that the work orders can be edited (add or remove) without always changing the data table.

Because there are multiple clients, and each client will have a different work order since they have different items to be inspected.

Thank you in advance & kind regards.

[dpoggemann]

Hi @Nass_ 

What do you mean "without always changing the data table" in your question above?  I am guessing based on your question you are looking for something like this model?

[Nass_]

Hi @dpoggemann 

Thank you for your response, 

Yes so basically I was thinking I would create an extra table for "work order items", in which we can store the client name, item details, inspection value and a reference with a work order ID. That refers to another table containing Work Orders.

That way, we can link the "work item list" based on the work order ID to the main "work order" table.

But I don't really know if this is best practice ?

Thank you for your help on this.

[dpoggemann · Accepted solution]

Hi @Nass_ 

This is best practice from my background and provides great flexibility to add fields on that intersect entity as I defined.  

[Nass_]

@dpoggemann 

Thanks a lot for sharing your experience ! 🙂