I'm working on a risk analysis and mitigation scheme. I want to keep track of different risks within a list. As there are different classes of risks (time delay, direct money loss, nonperformance) I have added a column (multiple select) to reflect that type. I don't want to have the individual columns dealing with the specialities of the different risk types in every line. I thought about defining content types, but an object can only be of one content type, while a certain risk in a project can inflict e.g. time delay as well as money loss. My idea is now to have three more lists auto generated from the main list, containing all the elements belonging to a certain risk class. I tried to use lookup columns, but they don't do anything automatically. I think the biggest difficulty stems from the fact, that I want the elements of a list to be copies of the elements in the master list but also be able to hold individual data inside that smaller list.
My fallback solution is to put everything in my master list and use filtered views. But I consider that messy.