Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Linking two tables in MS Access?
I am trying to link two different tables in Access so that changes made in one will be updated in the other. If such a thing is possible. I know a query can do that but you can not write data to a query from Visual Basic.
I have one big table called tblCustomer and I have a smaller table called tblTrip that contains 4 of the fields in tblCustomer. I need a way to make it so that changes made to tblTrip will be reflected in tblCustomer and vise versa.
Is it possible and if so how?
3 Answers
- Anonymous1 decade agoFavorite Answer
go to the database tools then relationships.. and link the primary key of the tblCustomer to the foreign key of tblTrip..
Source(s): IT student - cockmanLv 45 years ago
get right of entry to can't do this. you're able to would desire to enter the archives your self till you write some code which will finished this for you. you're able to desire to do a Append question to append all the counsel from one table to a distinctive. yet for what your desirous to do this sounds greater like some code writting to get it to do merely what you like it too.
