I need to display all the statuses an equipment has gone through since its date of inception alongwith the dates in a report
01.01.2008 - Available
02.01.2008 - Installed
03.01.2008 - Inactive
how can i get all the respective equipment statuses alongwith the dates. Please tell the tables also.