In Filemaker, if table 1 contains an employee ID related to table 2 which contains employee data, and entered an employee ID in table 1 that did not exist in table 2, no related data would be shown.<br><br>As I mentioned before, you can force Filemaker to be more fussy by using validation rules, but it's not a simple tickbox next to "Enforce Referential Integrity" :-)<br>
<br><br>On Fri, Mar 26, 2010 at 3:49 PM, Mike Brookes <span dir="ltr"><<a href="mailto:mikebr@tpg.com.au">mikebr@tpg.com.au</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div bgcolor="#ffffff" text="#000000">
Normalising a database is a process for making the design of tables
more efficient.<br>
<br>
<a href="http://databases.about.com/od/specificproducts/a/normalization.htm" target="_blank">http://databases.about.com/od/specificproducts/a/normalization.htm</a><br>
<br>
Referential integrity is about preventing the user entering a value in
a foreign key field which does not exist in the key field of the table
being looked up.<br>
<br>
If Filemaker does not enforce referential integrity what does it do if
it can't link the two tables?<br>
<br>
Mike Brookes<br>
Chief cook and bottlewasher<br>
Copperfield College<div><div></div><div class="h5"><br>
<br>
<br>
On 26/03/2010 3:02 PM, Mark KELLY wrote:
</div></div><blockquote type="cite"><div><div></div><div class="h5">Apologies for all the posts, but the new design is an
interesting beast.<br>
<br>
ITA U3O2 Key Knowledge 11 - <b>"ways in which normalisation can ensure
the integrity of data in an RDBMS"</b><br>
<br>
Assuming they mean "referential integrity", this will be an interesting
dotpoint if you're using Filemaker which does not use the concept of
referential integrity*<br>
<br>
<br>
*Except as an awkward kludge by using a validation rule ("exists in
limited list") and defining the list to include values in a foreign key
field.<br clear="all">
<br>
-- <br>
Mark Kelly<br>
Manager - Information Systems<br>
McKinnon Secondary College<br>
McKinnon Rd McKinnon 3204, Victoria, Australia<br>
Direct line / Voicemail: 8520 9085<br>
School Phone +613 8520 9000<br>
School Fax +613 9578 9253<br>
<a href="mailto:kel@mckinnonsc.vic.edu.au" target="_blank">kel@mckinnonsc.vic.edu.au</a><br>
<br>
Webmaster - <a href="http://www.mckinnonsc.vic.edu.au" target="_blank">http://www.mckinnonsc.vic.edu.au</a><br>
IT Lecture notes: <a href="http://vceit.com" target="_blank">http://vceit.com</a><br>
Moderator: IT Applications Mailing List<br>
<br>
<br></div></div>
_______________________________________________
<br>
<a href="http://www.edulists.com.au" target="_blank">
http://www.edulists.com.au </a> - FAQ, resources, subscribe,
unsubscribe <br>
IT Applications Mailing List kindly supported by <br>
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html%20" target="_blank">
http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html </a>
- Victorian Curriculum and Assessment Authority and
<br>
<a href="http://www.vitta.org.au" target="_blank">
http://www.vitta.org.au </a> - VITTA Victorian Information Technology
Teachers Association Inc</blockquote>
<br>
_______________________________________________
<br>
<a href="http://www.edulists.com.au" target="_blank"> http://www.edulists.com.au </a> - FAQ, resources, subscribe, unsubscribe <br>
IT Applications Mailing List kindly supported by <br>
<a href="http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html" target="_blank"> http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html </a> - Victorian Curriculum and Assessment Authority and
<br>
<a href="http://www.vitta.org.au" target="_blank"> http://www.vitta.org.au </a> - VITTA Victorian Information Technology Teachers Association Inc</div>
</blockquote></div><br><br clear="all"><br>-- <br>Mark Kelly<br>Manager - Information Systems<br>McKinnon Secondary College<br>McKinnon Rd McKinnon 3204, Victoria, Australia<br>Direct line / Voicemail: 8520 9085<br>School Phone +613 8520 9000<br>
School Fax +613 9578 9253<br><a href="mailto:kel@mckinnonsc.vic.edu.au">kel@mckinnonsc.vic.edu.au</a><br><br>Webmaster - <a href="http://www.mckinnonsc.vic.edu.au">http://www.mckinnonsc.vic.edu.au</a><br>IT Lecture notes: <a href="http://vceit.com">http://vceit.com</a><br>
Moderator: IT Applications Mailing List<br><br><br>