Lost record info? Where did it go?

[Mr.Morning]

We have a simple PO system with 1800 records.

On 175 of the early records all the cost entrees have disappeared. They were all originally recorded because we have hard copy run outs but on screen these first 175 now have no cost entry info or totals?

I do not know how human error could be a factor because that's a lot of human error, especially when it's all in a row from the front.

Any thoughts would be appreciated, could the amount of entrees be too much for it so early info is now being deleted?

Any help would be appreciated.

Thanks in advance,

morning man

[-Queue-]

Are the cost entries lookups or manually-entered? Do you have a 'last modified date' field that can tell you when the records changed? Info would never be automatically deleted unless a human programmed it to do so btw.

[BobWeaver]

Is it possible that there was a design change at one point where some old fields were abandoned and new ones created. Maybe the data is still there, but in different fields.