If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Relationship or Append Query?
I have two tables and created a form to enter data into one of the tables.
PROBLEM I need to have data from a few fields in one table automatically populate the same few fields in the other table when new information is input into the form. 1. Data is input into Table 1 (new table)by using a form. 2. Field B and Field C need to auto-populate when information is entered in Field A. 3. The information should feed to Fields B and C in Table 1 mirror data in Table 2 (old table). I know I need to create some sort of relationship. I tried lookup but that is not appropriate for this task. I created an append query, but do not know how to tell the query to associate information from Table 2 (old table), to information in fields A, B, and C in Table 1 (new table). Also, there are only 302 records in Table 1 (new table), but the append query returns over 22,000 records from Table 2 (old table). TABLE 1 (new table) Field A (new data entered) Field B (auto-populate based on Table 2 [old table]) Field C (auto-populate based on Table 2 [old table]) Fields A, B, and C related to one another. For instance: Field A = Sales Exec (there are 5 sales execs) Field B = Company buying product Field C = Company buying product's agency I explained this as best I could so I hope it is understandable. I need step-by-step, no shortcuts, plain language info because I am not fully versed in the language specific to the Access genre. Thanks in advance. |
#2
|
|||
|
|||
At least you don't expect too much for free.
In the AfterUpdate of the Form, use Append Queries to write the data to the needed tables. -- Steve Clark, Access MVP FMS, Inc. www.fmsinc.com/consulting "jcinn" wrote in message ... I have two tables and created a form to enter data into one of the tables. PROBLEM I need to have data from a few fields in one table automatically populate the same few fields in the other table when new information is input into the form. 1. Data is input into Table 1 (new table)by using a form. 2. Field B and Field C need to auto-populate when information is entered in Field A. 3. The information should feed to Fields B and C in Table 1 mirror data in Table 2 (old table). I know I need to create some sort of relationship. I tried lookup but that is not appropriate for this task. I created an append query, but do not know how to tell the query to associate information from Table 2 (old table), to information in fields A, B, and C in Table 1 (new table). Also, there are only 302 records in Table 1 (new table), but the append query returns over 22,000 records from Table 2 (old table). TABLE 1 (new table) Field A (new data entered) Field B (auto-populate based on Table 2 [old table]) Field C (auto-populate based on Table 2 [old table]) Fields A, B, and C related to one another. For instance: Field A = Sales Exec (there are 5 sales execs) Field B = Company buying product Field C = Company buying product's agency I explained this as best I could so I hope it is understandable. I need step-by-step, no shortcuts, plain language info because I am not fully versed in the language specific to the Access genre. Thanks in advance. |
#3
|
|||
|
|||
"[MVP] S.Clark" wrote: At least you don't expect too much for free. In the AfterUpdate of the Form, use Append Queries to write the data to the needed tables. -- Steve Clark, Access MVP FMS, Inc. www.fmsinc.com/consulting "jcinn" wrote in message ... I have two tables and created a form to enter data into one of the tables. PROBLEM I need to have data from a few fields in one table automatically populate the same few fields in the other table when new information is input into the form. 1. Data is input into Table 1 (new table)by using a form. 2. Field B and Field C need to auto-populate when information is entered in Field A. 3. The information should feed to Fields B and C in Table 1 mirror data in Table 2 (old table). I know I need to create some sort of relationship. I tried lookup but that is not appropriate for this task. I created an append query, but do not know how to tell the query to associate information from Table 2 (old table), to information in fields A, B, and C in Table 1 (new table). Also, there are only 302 records in Table 1 (new table), but the append query returns over 22,000 records from Table 2 (old table). TABLE 1 (new table) Field A (new data entered) Field B (auto-populate based on Table 2 [old table]) Field C (auto-populate based on Table 2 [old table]) Fields A, B, and C related to one another. For instance: Field A = Sales Exec (there are 5 sales execs) Field B = Company buying product Field C = Company buying product's agency I explained this as best I could so I hope it is understandable. I need step-by-step, no shortcuts, plain language info because I am not fully versed in the language specific to the Access genre. Thanks in advance. |
#4
|
|||
|
|||
Thanks for making me laugh--I really did need it considering the expectation
that I figure out how to accomplish the task 5 hours ago, and in 1/2 an hour or less.... Okay, I went to the form and did the following: 1. opened it in design view 2. right clicked on the mouse to get form properties 3. after the menu popped up, clicked on the "event" tab 4. located the after event row. 5. another window opened up and gave me the following choices: a) expression builder b) macro c) code builder 6. assumed I should click on "expression builder" 7. became royally confused after the expression builder opened 8. decided to reply to your message for more clues on how to proceed so that I do not mess up the data in the table linked to the form (translation--so I do not get fired.) I truly appreciate your feedback. Thank you! "[MVP] S.Clark" wrote: At least you don't expect too much for free. In the AfterUpdate of the Form, use Append Queries to write the data to the needed tables. -- Steve Clark, Access MVP FMS, Inc. www.fmsinc.com/consulting "jcinn" wrote in message ... I have two tables and created a form to enter data into one of the tables. PROBLEM I need to have data from a few fields in one table automatically populate the same few fields in the other table when new information is input into the form. 1. Data is input into Table 1 (new table)by using a form. 2. Field B and Field C need to auto-populate when information is entered in Field A. 3. The information should feed to Fields B and C in Table 1 mirror data in Table 2 (old table). I know I need to create some sort of relationship. I tried lookup but that is not appropriate for this task. I created an append query, but do not know how to tell the query to associate information from Table 2 (old table), to information in fields A, B, and C in Table 1 (new table). Also, there are only 302 records in Table 1 (new table), but the append query returns over 22,000 records from Table 2 (old table). TABLE 1 (new table) Field A (new data entered) Field B (auto-populate based on Table 2 [old table]) Field C (auto-populate based on Table 2 [old table]) Fields A, B, and C related to one another. For instance: Field A = Sales Exec (there are 5 sales execs) Field B = Company buying product Field C = Company buying product's agency I explained this as best I could so I hope it is understandable. I need step-by-step, no shortcuts, plain language info because I am not fully versed in the language specific to the Access genre. Thanks in advance. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can I 'autonumber' an append query? | Andrew | Running & Setting Up Queries | 2 | December 17th, 2004 08:42 PM |
Key Violation Error on an Append Query | BC | General Discussion | 6 | December 3rd, 2004 02:27 PM |
Key Violation Error on an Append Query | BC | Running & Setting Up Queries | 6 | December 3rd, 2004 02:27 PM |
Using an append query with an update query | Joshua Schairbaum | Running & Setting Up Queries | 1 | July 15th, 2004 02:22 AM |