My OS is windows 7 and I use Access 2007. I have 2 tables, Table A and Table B.
Both table's structure are the same. In Table A, in addition to the ID field it also has a field called ACS Keyline. While table B has the same field, but there are no data as the User had exported the Table but excluded this field. How do I update Table B with the ACS Keyline field from Table A, when the ID fields in Table A and Table B are equal. The data structure in both tables of the ID are identifical. Hope my problem makes sense. Please give me the steps on how to achieve them hopefully be as basic as possible. Thank u.