Sometimes there is a need to query data pertaining to only specified columns from a sharepoint list. Let's say I have a list " Employee " with columns - Name, ID, Age, Sex, Address, SSN etc. and I just want to retrieve data corresponding to columns...

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...