Ok, now a follow on to what happened above. The "mass deletion" of certain records happened again! I've found that it's related to import/export work we're doing and it's weird. Here's the story...
This issue is kind of hard to explain, but will do my best. We have a report that filters to only certain columns. In simple terms, lets say the columns in the main table are A B C D E F G H. The columns we filter for the record (to display) are A B F G H, leaving out C D E. The record ID is included as a key for re-import later.
So.... we modify the fields in the report as needed, then import this data back into the main table. The process shows that all columns are correctly match up and "green", so the import is done. Now however, the main table now shows all blanks or empty values in columns C D E! This, even though these columns were never exported, and therefore were never modified or touched.
I also should note that there are other columns the are filtered out or even switched in display order in this report that are further to the right in the main table, but everything in this region seems to be unaffected on the main table after this import. I'm totally baffled. Any ideas?
Thx,
Mark
