If the columns in common between the tables have unique values, you can define them as foreign keys with the ON UPDATE CASCADE constraint (assuming the database supports foreign keys - I know SQLite only recently added support for them). When you update the column in the table being referenced, it will automatically update the column in the other table. I'm not certain if it works the other way around, but I think it does. Dybs The shout of progress is not "Eureka!" it's "Strange... that's not what i expected". - peterchen