Relationships

  • Thread starter Thread starter Douglas J. Steele
  • Start date Start date
D

Douglas J. Steele

To be honest, I don't see what difference it makes that you're using unbound
forms and SQL statements.

To me, a major reason to use relationships is to enforce referential
integrity.

Remember that it's possible for others to use your data without using your
forms.
 
Maybe I'm putting the Cart before the horse but....Relationships.
I'm using unbound forms with mostly SQL statements behind them, do I still
need to define the relationships between tables, and if so why?
Thanks
DS
 
In addition to preventing inappropriate entries from being made, RI can
provide (should you want) cascade deletes or cascade updates.

As I stated before, remember that it's always possible for others to use
your data without using your forms. The more you can do to protect the
integrity of the data, the better.
 
Thanks Douglas, that clears things up a bit! So when you say referential
integrity, do you mean that a record can't be entered on any without having
entered the main record first? Would this matter with the SQL statements
since its pretty well controled?
Thanks
DS
 
Back
Top