I know this is a really basic question - but I can't find the answer.
I have a database with 2 tables. Table A has the following fields: Original ID, Visits, Allowed (primary key is auto number ID). Table B has Original ID, FQVisits, RVisits, FQNet, RNet, Visits, Allowed (primary key is auto number ID). I set the tables up with a join relationship between original ID.
On Table B the Visits and Allowed columns are empty. I want to bring the Visits and Allowed amounts from Table A to Table B, putting them with the correct Original ID. Not all Original ID's in Table A are in Table B, however, all Original ID's in Table B are in Table A.
Any help would be appreciated.
Thanks,
Jeanie
I have a database with 2 tables. Table A has the following fields: Original ID, Visits, Allowed (primary key is auto number ID). Table B has Original ID, FQVisits, RVisits, FQNet, RNet, Visits, Allowed (primary key is auto number ID). I set the tables up with a join relationship between original ID.
On Table B the Visits and Allowed columns are empty. I want to bring the Visits and Allowed amounts from Table A to Table B, putting them with the correct Original ID. Not all Original ID's in Table A are in Table B, however, all Original ID's in Table B are in Table A.
Any help would be appreciated.
Thanks,
Jeanie
