Re: Referrential Integrity Question

In article <3t1l0c$7n3@cssun.mathcs.emory.edu> jvemo@cyberspace.com "Jon C. Vemo" writes: > What is the best approach to insure referrential integrity at the server, > between two tables when: > - The parent table (tab1) has a primary key on (col1,col2), and contains> many rows with duplicates in col1 > - The child table (tab2) contains (col1) values with a contraint > before an > insert or update (i.e. tab2.col1 values must exist in tab1.col1)> > FWIW: Running under OnLine DSA 7.10 Are 'parent' & 'child' acceidentally swopped in the posintg? -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================