Hi,<BR><BR>I have an Access 2000 database.<BR>And I have 3 tables: categories, sub-categories and records.<BR>The relationship between them is one-to-many (from categories to sub-categories and from sub-categories to records).<BR><BR>Now I&#039;ve added a new column to the records table in which I want to put the categories id number (I have a field which holds the sub-categories id number).Yes, I know, I&#039;ve should have done this earlier...<BR><BR>The problem is that I have already some data in the records table (about 5000 records) and I don&#039;t want to put by hand in every records the id number of the categories.<BR><BR>Anyone knows some automatic way to do it?<BR><BR>Thanks,<BR>Mircea