tables...somthing..somthing...god knows

[chazhead]

Hello everyone, here is my problem.

I have two tables. I am trying to get a field in one populated from a
field in another....I'll try and clarify this a bit.

Table_1 contains the fields:

Resource_ID (key)
Resource Name
Tower

Table_2 contains the fields:

ID
Project Number (key)
Resource (key)
Tower

When an entry in Table 2 is made, the 'Resource' field is populated
from a lookup from 'Table_1 Resource Name'

What I want is for the 'Tower' field in table_2 to auto-populate from
the 'Tower' field in table_1 based on the selection of 'Resource' in
table 2.

I hope that makes sense?

Can this be done or am I dreaming

Thanks in advance.

 

[Douglas J. Steele]

Sorry, but no, you don't want that.

Tower shouldn't be stored redundantly in Table_2. All you should be storing
in Table_2 is Resource_ID. You can then create a query that joins Table_1 to
Table_2 on Resource_ID, and use that query wherever you would otherwise have
used Table_2

 

[chazhead]

Cheers Doug, that makes perfect sense.