Access, Access 2000, Access 2003, Access 2003 forms, Access 2007, Access 2007 forms, Access 2007 functions, Access control, Access Database, Access forms, Access Points, Access query, Access Tables, Clustering, CSV, Database administration, Database connectivity, Database design, Database issues, Database management, Database Management Systems, Database migration, DB2, DB2 administration, DB2 Universal Database, DB2/400, DBA, DBMS, Embedded SQL, Flat files, FoxPro 2.6, IIF function, IIF statement, INSERT statement, JDBC, JOIN statement, Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access forms, Microsoft Access subforms, MySQL, MySQL Database, ODBC, QMF, Query optimization, SQL queries, Sybase, Triggers VIEW ALL TAGS
What is referential integrity in DB2/400? & What is field reference file in DB2/400?
Can anyone please explain what refrential integrity means and how does it relate to AS/400? Regards, Shaddy
quick question about referential integrity: let's say i have 4 tables: A table has NAME B table has NAME, CODE C table has CODE D table has NAME, CODE, ELSE A (NAME) is referenced by B (NAME)and C (CODE) is Referenced by B (CODE) if i reference B (NAME, CODE) from D, do i need to reference A (NAME)...