Relationship or Append Query?

[jcinn]

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.

 

[[MVP] S.Clark]

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.

 

[jcinn(cylvia)]

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

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.

 

[jcinn]

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!

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

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.