Getting data from two sources into one table
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
January 14, 2013 5:48 PM
UPDATED:
January 14, 2013 6:33 PM
RELATED QUESTIONS
- Auto-Populate an Access form using a table of values
- automatically populate field sequentially from list
- Access 2007 - Controlling Master ID when launching detail form from master form
- Issue with a sub procedure and its arguments.
- Using combo box to populate a sub form which is used to create a new record
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
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.