Does anyone foresee (or have words of warning) about adding persistent relationships to an application's database?
My app is already up and running fine: each form or report establishes own data environment. The DBC contains no stored procedures or reference definitions. (That's just the way the app got designed.)
Now, my users have discovered the complexity of deleting parent records tied to children using meaningless primary keys and not taking the children with them. Worse, not being able to recreate the parent and have the children suddenly reappear again.
So, someone suggested establishing persistent reltionships in the database and letting code(?) and native VFP handle the referential integrity. (Hmmm ... I've not done this before but I think I can figure it out ...)
Words of wisdom for weary code warrior humbly requested ...
Thanks in advance.
Ernie Veniegas
Micro System Solutions
... sensible software by design