Re: Query that calls value from one table field to another table f

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" wrote:

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." <LisaW@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:32EDDE3C-DD0A-42A3-84C1-3640A95EF8C8@xxxxxxxxxxxxxxxx
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.



.

Quantcast