I’m fairly new to MongoDB, so not sure if this easily fits into a data modeling pattern.
We have a collection of contracts (essentially construction work to be performed), and for each contract, we need to, in our application, creating a cascading list of values.
- In the first drop down I select a specific region.
- The region I selected in the first drop down should filter the second drop down to a specific list of grids for that region.
- Then, based on a combination of the region and grid selected in the 2 preceding drop downs, the third drop should be filtered to a specific list of circuits.
I’m trying to figure out the best way to model the relationship between the potential values in each drop down, for each contract. Is there a modeling pattern, or other design pattern that others have used, that has worked well for this? To note, the possible list of values in the 3rd drop down, could be in the thousands - this is why we have the first and second drop down, to filter to that specific list.
I couldn’t find a topic that seemed similar to this, but if this question has been posed before, happy to research the responses given there.