Strange Data Behavior

[Russ]

I have this application running in a multiuser
environment. The problem is that records from two of the
table simply vanish over time (a couple of days or even
weeks). Someone suggested that the data tables be linked
in a primery (parent) secondary (child) relationship.
This, had been done from the very start. This linking
would limit the vanishing affect of data, due to the
cascading update or delete structure of the link. Data
could not just simply disappear on it's own, especially in
the foreign tables. However, the vanishing of data still
continues.

Any ideas? Has anyone seen this sort of thing previously?

HELP!!!!!!!