I was doing some reporting recently, where I needed to compare dues payments by member category. I thought that since I was doing historical reporting, the activities table was the place to go. It contained the transaction date, amount, product code. I started using the category field from the name table (which i joined to activities), however I soon realised that I needed the historical member category, not the current one. To my disillusionment I found that iMIS does not populate the Category field in the activity table (Even though there is a space for it!). We did however have historical category information in the name_log table. So I set about to create a SQL script to back-populate the category field in the activities table based on the information in the name_log table.