Getting data from two sources into one table

5 pts.
Tags:
Microsoft Access 2010
Microsoft Access tables
I have a form that will add data to say mainTable. In the form, I want to get some data like last name, first name and client_number from a linked master table (using a combo box) and have that data added into mainTable . I would also like to enter data (last name, first name and client_number) that are not in the master table, but I don’t want the new data to be added to the master table. I just want the new data to be added to mainTable . So mainTable will have data from the master table and also have data that was added using the form. How do I go about doing this?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • jailall101
    INSERT INTO mainTable (firstName, lastName,clientNum) VALUES (f_name_field, l_name_field, c_num_field); You didn't specify how you want to enter the new data into the main table. I assumed you're also using a form in which case f_name_field, l_name_field, c_num_field will be the name of the form fields that you will be using to enter the data.
    735 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following