I’m now starting a new project where we change the network infrastructure from our business customers. This happens in a rollout and is achieved through various milestones.
We have two different services. For each service there are 12 milestones that need to be filled out by different persons. The goal is to see on each customer, what milestone is active and which milestones are in which status (not started, active, closed).
To achieve this I thought about making a table for our customers called customerDB. And for every milestone I make a separate database which is referenced throught a UniqueID or customer name to the customerDB.
Making those milestones visible on a customer is not a problem for me, I’m also working with slices to show the correct service milestones dependent on the service that is chosen in the customerDB.
My problem is, that I can’t find a way to put data from milestone databases to the customerDB when data in the milestone changes.
If I have 5 milestones with different status: Milestone 1 (closed) Milestone 2 (active) Milestone 3 (active) Milestone 4 (not started) Milestone 5 (not startet)
Is it possible that I have a column in the customerDB which is called “active milestone” that always shows the lowest active milestone? (In this case, milestone 2)
A solution to this would help me with a lot of other apps, as they get more and more complex.
I hope this is somehow understandable.
Thanks in advance.