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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referential Integrity and Forms 11
autonumber relationship 5
Referential Integrity Unavailable 2
Rollback changes in subform when subform lost focus 1
Validate value exists in another table 2
Referential Integrity 4
Creating a relationship in Access 1
Relationship must be on the same number of fields with the same... 9

Back
Top