hello everybody I looked at the setup of both tables and found that the key in the first, made up of two fields, had each field NOT NULL
So I applied this to the single field key in table2 - Trade Number Now - no errors :) Thanks to all, for such great advice Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-2-derby-tables-tp147386p147437.html Sent from the Apache Derby Users mailing list archive at Nabble.com.