Query that calls value from one table field to another table field

[Lisa W.]

I have a query where I need the table (Station) first name field and last
name field to populate to another table (Admin) field. The query is linked
by "Phone Template". The purpose of this is due to needing the data field
from the second table to import into a tool used by my company. The field
names are CPND_FIRST_NAME and CPND_LAST_NAME, which come up blank when the
query is run.

Is there a way to have the names from from Station Table field to populate
in the Admin Table field within the query?

Thanks in Advance,
Lisa W.

 

[Jeff Boyce]

Lisa

I may not use the same definition of the term "populate". It sounds like
you are asking for a way to copy data that's already stored in one place
into another place. It is rarely necessary to do so in a well-normalized
relational database.

Can you clarify what you are trying to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Lisa W.]

I'm trying to get the data from Table 1, Field "x"), to show up in Field "z",
from Table 2.

 

[Lisa W.]

More details:

Table 1:
Table Name: Station_DataSheet1
Field Name: First Name

Table 2:
Table Name: Admin
Field Name: CPND_FIRST_NAME

Criteria: [Station_DataSheet1]![First Name]

**I want the first name that's in Table 1, to show up in the CPND_FIRST_NAME
field in table 2. Is this possible?

Thanks,
Lisa W.

 

[Jeff Boyce]

Yes.

Now, WHY?! (just because it is possible doesn't make it a good idea -- I'm
raising this question to help determine if it is...)

Again, in a well-normalized relational database, you DON'T want to store the
same data (e.g., firstname) in more than one table.

In a spreadsheet, maybe yes, but there's no need to do so in Access...

Regards

Jeff Boyce
Microsoft Office/Access MVP

More details:

Table 1:
Table Name: Station_DataSheet1
Field Name: First Name

Table 2:
Table Name: Admin
Field Name: CPND_FIRST_NAME

Criteria: [Station_DataSheet1]![First Name]

**I want the first name that's in Table 1, to show up in the
CPND_FIRST_NAME
field in table 2. Is this possible?

Thanks,
Lisa W.

Lisa

I may not use the same definition of the term "populate". It sounds like
you are asking for a way to copy data that's already stored in one place
into another place. It is rarely necessary to do so in a well-normalized
relational database.

Can you clarify what you are trying to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP