A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Relationship or Append Query?



 
 
Thread Tools Display Modes
  #1  
Old February 9th, 2005, 05:35 PM
jcinn
external usenet poster
 
Posts: n/a
Default 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  
Old February 9th, 2005, 07:17 PM
[MVP] S.Clark
external usenet poster
 
Posts: n/a
Default

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  
Old February 9th, 2005, 08:23 PM
jcinn(cylvia)
external usenet poster
 
Posts: n/a
Default



"[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  
Old February 9th, 2005, 08:23 PM
jcinn
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I 'autonumber' an append query? Andrew Running & Setting Up Queries 2 December 17th, 2004 09:42 PM
Key Violation Error on an Append Query BC General Discussion 6 December 3rd, 2004 03:27 PM
Key Violation Error on an Append Query BC Running & Setting Up Queries 6 December 3rd, 2004 03:27 PM
Using an append query with an update query Joshua Schairbaum Running & Setting Up Queries 1 July 15th, 2004 02:22 AM


All times are GMT +1. The time now is 08:18 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.