Tag: error resolution

In 5 (Often Forgotten) Productivity Tools I mentioned that List Views are a great way to review data. However, the TMS interface expects the SQL view to return only one row per selected record. If your table joins create more than one row per record, then TMS will truncate the SQL view results. If your table join excludes records, then TMS will repeat rows in the SQL view results. Either way, you get an Invalid property array index error and confused end-users. Here’s how to avoid it altogether.