Hi This is the second office with a similar strange problem. About once very 3-4 wks they get some strange data saved in our daily transaction table. One iffice kept getting a charge for Custnum 0 which did not exist in the Customer table, another one got custnum 5897473 and they do not have that custnum. We have PK's and FK's and you can not save a row of data without entering a valid custnum. Also most of the other columns have strange data, like dates of 1899, #$%^ in some fields, currency numbers that look like the deficit and so on.
I figure this is some static / junk data coming from the network and getting stuck in the daily trans table or ???? I still wonder how it got saved in the first place or was the data valid at one point then somehow it gets changes? I know the user can not do this and save the row because of the PK / Fk's. Any thoughts? thanks Marc
