Hi Gunter, many thanks. Just to be clear as I'm a complete noob at this stuff, do you mean the schema of table2 or table1? Table1 can't be changed as I import new data dailt in csv format as needs to match the table format exactly otherwise DB4S will allow the import. And do I replace the word 'field' with column name? To put it very simply, if I add a single column in table2 and put a row with ABC123 in the cell, I want all rows in table1 with ABC123 to disappear from view (the column names will match). Sorry for any confusion! Thanks & rgds. Rob