Saving fields from form to a different table.

A

Antonio

Hi everyone.

I have three tables linked. Contacts, BillingAddress and ContactMessages.
Then a form containning some of the fields from each of the three tables.

I wonder if there is some way to create a button with an event, macro etc..
so when I click it, those (and only those) fields shown on the form get added
to a different table ( i.e. Orders).

Any help would be very much appreciated.
 
A

Arvin Meyer [MVP]

Since all the tables mentioned probably have a ContactID, you only need to
add that to your Orders table. Specific data should never be duplicated,
other than the Key.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appending tables 0
Finding the right style field in VBA 0
Data entry for a table from a form 2
Finding the proper style field and the numbered paragraph value within the style 0
Auto-Numbering in a Table in MS Word 1
Data entry to table from a form 0
form fields not saving to table 2
Joining data from different fields into one fieled 3

Top