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

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 spread***, maybe yes, but there's no need to do so in Access...

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Lisa W." <LisaW@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:32C02541-F754-4F87-8588-FBB753EC93F2@xxxxxxxxxxxxxxxx
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.





.