Hi This is the second call I received about strange data in my transaction table, the first one was 6-12 months ago. As luck would have it this user just updated to 7.6 and my latest app and they also got new computers.
Our transaction table has a FK on the custnum column, the user gets custnum's like 0 or some other invalid number, also the date fields have strange numbers that do not even look like a date. I told the user it is most likely bad packets of junk data from their network. So far my only solution is to add a line of code that Deletes Rows where the custnum does not Exist....the Pack the table. They also leave their computers on 24/7 so I suggested rebooting each AM. Is there anything else I can do? Thanks Marc
