I have 2 tables.... table A and table B. Table A has about 20 fields and Table B has 2 fields, 'Business_Phone, and P_ID. Table A has Business Phone too. Can i write an append query for checking both tables for 'Business_Phone' and If 'Business_Phone in Table A matches 'Business Phone' in Table B then the P_ID from Table B is coppied to the corresponding Business_Phone row in Table A.
Table A Table B
P_ID (currently empty)
So if there is a way to compare the 2 Business phones and if they match take the P_ID from Table B and put it in P_ID of table A.
Thanks for the help.