Thanks for the help!  Sorry I haven't responded before now, but I wasn't able to get onto the site for the past 2 days.

Quick question - The update and insert states do not need to loop through the tables?  In other words, will I have to code a loop to read each line in the table2 and nest your suggested code within it? -- Xitch13 ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------

Determining financial year quarter
==again== constraints with nulls
(Non) Updatable view problem
Help with this trigger
unique constraints with nulls