I have a table with room details including room user(employee) info. Users can be change at any time, new users can come in, room functions can be change, etc. Here I want to get the status(users-function-ant other room info) of a particular room or all rooms status in the building as of a single date. for example, get a report like who was using the room and what was the function of that room in 1/12/2013. There is a date field in the table to show the last updated date of that room.Shall we need to add more fields(date) to the table to generate this kind of reports.
I just want to collect the better options from you experts that will help me to go right direction in development.Please help