Thanx Glenn,...
I am experiencing about joining only in queries, not in the tables...and i think everything is okay although
i have more effort to delete all of the records in the child (many side) everytime i deleted the records in
parent. I know that Access will index automaticly to child fields when we build relationships...so i have
indexed manually all of the fields in Child.
The reason i do not buid relationships between tables and not implement RI is someone told me that
building relationships between tables will make slow all of the process,,,Please give me more direction..
Regrds
Hendra
________________________________
Dari: Glenn Lloyd <argeedblu@gmail.com>
Kepada: MS_Access_Professionals@yahoogroups.com
Dikirim: Senin, 27 Februari 2012 22:38
Judul: RE: [MS_AccessPros] Relationships
Hi Hendra,
Relationships are a different issue than having indexed fields on the many
side. In my opinion, the most important aspect of building relationship is
the possibility of enforcing referential integrity. Without referential
integrity, it is possible, even probable, that orphaned records will get
created in the many table. So you could, for example, have Invoices without
customers, and invoice details without invoices. Orphaned records are
absolutely undesirable. So yes you still should have relationships
established.
Glenn
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
agesthahendra@ymail.com
Sent: February-27-12 10:30 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Relationships
Hi All,..
Assumed :
- We have indexed all of the foreign key on many sides
- All Join are builded in Queries as we need
- Ignoring Enforce Reffrential Integrity
Do we still have to build relationships between tables..? What about
performance..? Are there any performance effects if we don't build
relationships between tables..?
Any explanation would be appreciated, thank you...
Regards
Hendra
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar