I was on this engagement where I had to make use of management information stored in MS Access 2007 and MS Excel 2007 in a share point 2007 site. It’s been 150 years since I used Access to do some basic database management stuff in a small library...

Before I got to know about what I am going to write here, I was pretty convinced that there is no way to establish a relationship between two lists using lookup columns in case of the source column having multiple copies of data. Using OOTB features...