do I need relationships? (1 Viewer)

[gillbates21]

When I use onlySQL and INSERT, UPDATE and DELETE queries to manipulate data in my tables then do I need relationships


For example, if I insert data from a form, I use as many INSERT queries as needed to insert all the data to all the tables. All SQL.

 

[Pat Hartman]

Why would you think that action queries behind unbound forms are any safer than bound forms? Your action queries are quite capable of inserting/updating invalid data. Why even use Access if you are going to use unbound forms?

It is ALWAYS better to have the database engine enforce whatever RI it is capable of enforcing. Only if the db engine cannot enforce a business rule should you write the code to do it yourself.