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

form fields not saving to table 2
Separate Form 0
Data entry for a table from a form 2
Combining a data from a linked table and a regular table in one fo 2
Access Form - Lock Fields from Editing 0
Two Form Fields Reference The Same Table Field 3
Saving info to a table via Form 5
Joining data from different fields into one fieled 3

Top