Hi guys,
I have a list of consultants and the users (people who work for the company) are supposed to be able to search for consultants based on the time frame they worked for, for a company. For example, I should be able to search for all consultants who worked for Bear Stearns in the month of july. What is the best of accomplishing this? I was thinking of formatting the document like this <company> <name> Bear Stearns</name> <startDate>2000-01-01</startDate> <endDate>present</endDate> </company> <company> <name> AIG</name> <startDate>1999-01-01</startDate> <endDate>2000-01-01</endDate> </company> Is this possible? Thanks, Moazzam