We are working in web app where we have parent records that have multiple attributes that have many-to-one attribute values tied to them. We are attempting to list these parent records in a grid control and then want to be able to show the child records that are tied to these attributes that have these many to one attributes. Can anyone give some advice on how best to handle this and possibly point me to some examples?
Let me try to give an example here to better explain this. Let's you have a list of margarine products and the parent product is Imperial margarine which comes in different packages sizes and has more than one ingredient. So both the package sizes of the Imperial margarine and the ingredients within the margarine would be many to one - to the Imperial margarine parent. So if I wanted to display and store all the margarine products I sell in a hierarchy grid, the parent grid would contain all the different margarine brands (i.e Imperial, Country Crock, Blue Bonnet, etc.) with attributes related to the parent product (manufacturer, nutrition facts, etc) in that parent row. Then these many to one attributes like package size (with a list of it's attributes (package size details, retail price, inventory, etc), ingredients, etc need to somehow show in child rows. One way I was thinking of possibly doing this is if you clicked the parent you would see each of the many-to-one attributes as direct child's and then clicking on those nodes, would show their rows of records (i.e. package sizes of margarine).
Do people think that would work, any other ways people think this could be done?