DLOOKUP Help Please!

[Scott_66701 via AccessMonster.com]

I have the following tables in my database:

Table 1
Table 2
Table 3

I am wanting to use DLOOKUP to copy the value in Table1 in column named
"RunNumber" to Table3 in the column named "RunNumber3" I want DLOOKUP to
give the value on the current record that I am working on. Can someone
please give an example or show me the expression to use to get DLOOKUP to do
this. Thank you.

 

[Scott_66701 via AccessMonster.com]

I have the following tables in my database:

Table 1
Table 2
Table 3

I am wanting to use DLOOKUP to copy the value in Table1 in column named
"RunNumber" to Table3 in the column named "RunNumber3" I want DLOOKUP to
give the value on the current record that I am working on. Can someone
please give an example or show me the expression to use to get DLOOKUP to do
this. Thank you.

I have tried: RunNumber3=DLookup("RunNumber", "Table1", "RunNumber=" &
RunNumber" I'm sure I did this wrong.

 

[Douglas J. Steele]

Why? As in why would you want to store data redundantly?

Since obviously there's a relationship between the fields in the two tables,
just create a query joining them, and use the query wherever you would
otherwise have used Table3.