> Just a thought: I understand how relations between fields are > useful in Access when you use Access exclusively to enter or > search for data (e.g., through an Access form). However, if > you are accessing data only via SQL statements with CFML, do > the tables still need to be linked (relational) in Access? > Wouldn't you get the same results with two independent tables > (i.e., not relational) that are updated, inserted to, and > read via CFML using CFTRANSACTION (to do consecutive tasks > like getting the word ID and then updating/inserting in the > second database)?
No matter how you're accessing your data, you want the relations between records to be enforced by your database. If you don't use declarative referential integrity to enforce relationships between your records, your database becomes vulnerable to any mistakes within application code that might change one side of a relationship without appropriately changing the other side. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183997 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
