 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / April 2008Populate related table
I have two data input tables in which one need information from the other before the user can complete a row entry. Is there a way for me automatically populate the specific column data into table1 from table2 upon each in entry into table 2? Andre Adams Please translate: ' populate the specific column data into table1' Evi > I have two data input tables in which one need information from the other > before the user can complete a row entry. Is there a way for me > automatically populate the specific column data into table1 from table2 upon > each in entry into table 2? > > Andre Adams There are 3 columns that I want to automatically populate into table 2. (1) Date, (2) Amount and (3) Issuer. Those 3 columns are also in table1 and will be entered before any data is entered into table2. Its actually a prerequisite for the remaining data in table2. > Please translate: > ' populate the specific column data into table1' [quoted text clipped - 6 lines] > > > > Andre Adams >There are 3 columns that I want to automatically populate into table 2. (1) >Date, (2) Amount and (3) Issuer. Those 3 columns are also in table1 and will >be entered before any data is entered into table2. Its actually a >prerequisite for the remaining data in table2. A fundamental principle of relational database design is that you should store information only ONCE. Storing the date, amount and issuer redundantly in two tables is almost surely neither necessary nor a good idea! Bear in mind that the amount (say) could be edited in either Table1 or in Table2, so that the "same" record has two different amounts. NOT good! You're using a relational database. Use it relationally! Use a Query joining the two tables to retrieve the information from Table1 to be used in conjunction with information from Table2; it should not be necessary to copy the data into the second table. If you have a good reason for doing this... please explain.  SignatureJohn W. Vinson [MVP] Do you mean that you want to add the data in those columns to Table 2? If yes, then look up Append Query in Help. Evi > There are 3 columns that I want to automatically populate into table 2. (1) > Date, (2) Amount and (3) Issuer. Those 3 columns are also in table1 and will [quoted text clipped - 11 lines] > > > > > > Andre Adams |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.