I have two entities, Toolbox and Tool, where Toolbox contains a set of tools (hammer, saw, screwdriver).
The trick is that there can be several hammers in the same toolbox, so I need an amount, or quantity.
All in all the overlay looks like this:
Here my toolbox contains one Drill and two hammers.
Although SharePoint lists are far far from any database, one could imagine it like this:
Here ToolboxTool is a "joining table" connecting the two entities, with the additional information about Quantity. Of course in a normal database one could justify quantity by creating duplicates of ToolboxTool instances, but this is perhaps more SharePoint-like.
My actual question
What is the perfect way to setup something like this in SharePoint?
Several times I have faced similar problems when defining Lists, but I have never taken the step to find the perfect solution, which is why I ask here now.
Some virtual restrictions:
- I'm looking for OOTB solutions, but any suggestions are more than welcome.
- Does not have to be bound to foundation, but non-enterprise answers are preferred.
- OOTB presentation (e.g., XsltListViewWebPart) should be part of the consideration.