I'm developing a database for a client, and it has to be done in MS Access 2000. NOT Access xp, NOT Access 2003, it HAS to be Access 2000. I don't get to take advantage of the past five years of refinement and usability. Did you turn and walk away in disgust? No? Good. Can you help me? Here's what I need to do. There are two scenarios: 1. I need to create a new record in Table B using the data from the currently-active record in Table A. Table B has more fields than Table A, and the non-matching fields need to remain blank while the matching fields recieve exact copies of the data from Table A. 2. I need to detect when a field value in Table B has been changed, and then I need to find the only record in Table A which has the same primary key value as the newly-modified field in Table B. Then I need to re-copy the data from the new matching record in Table A into the newly-modified record in Table B, overwriting all previous data in the newly-modified record in the process. The more basic version of this (scenario 1) seems like it should be a common enough thing that Access would have a premade function to make it happen, but damned if I can find it. And the complicated version (scenario 2) is completely beyond my grasp of Access programming at this point. Please help me.