Getting data from table 1 to a form and then to table 2?

message from =?Utf-8?B?TXIgQg==?= on 13 May 2004
Howdy,

I have a bunch of text boxes that are bound to fields in a table. A user can search on the ID field or just scroll through the data to find the item he wants to view. What I need to do is then have a button that when clicked, will take the data from certain fields being displayed, and add a new record to a different table.

Thanks.
 
Lynn Trapp replied to =?Utf-8?B?TXIgQg==?= on 13 May 2004
Why do you need to store duplicate data? One of the reasons for building a
fully normalized relational database is to eliminate redundant data.
 

Archived message: Getting data from table 1 to a form and then to table 2? (Microsoft Access Database)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.