I have two lists, one contains files, each file has one or more ID(depending on its content). These IDs are lookups to another list. Now, I generate another list on fly, this list has the ID column as well (same lookup table). What I need to do is to somehow link the two lists together(many to many relationship i suppose) so that i could see all the files, that have one or more common IDs with the generated list. Any idea, how to do this? I could use SP Designer, Visual Studio or any other tool I guess..