Hi Travis---

What we're talking about here is a difference between theory and reality. Theory dictates that you maintain RI on the back-end, right? Unfortunately, the VFP DBC really stinks at doing this with decent speed. There are also, at times, buffering issues.

Soo....You are completely correct in theory. Indisputably. In practice, though, I have found it much quicker to maintain RI in a separate data or I/O or business classes. Do I like having to do that? No. Absolutely not and you'll not catch me doing that with a server database on the back-end like Oracle or SQL Server.


>I'm curious John, where, then would you implement the RI code if you don't do it the database?
>
>The reason I ask, is because that just so happens to be the exact job of the back-end: To handle the metadata (the data that tells it what records are related to others, etc.). Implementing that anywhere else would be foolish IMO.
>