Populate related table

[Andre Adams]

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

 

[Evi]

Please translate:
' populate the specific column data into table1'
Evi

 

[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.

 

[John W. Vinson]

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.

 

[Evi]

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