automating an entry

[briank]

One field in my master table is a lookup based upon
column 1 another table. Another second field in my
master table is based upon the same lookup table but at
column 2. I would like to have the user choose a
selection in the first field and have the second field
automatically populate. Is there a code for this?

 

[Tim Ferguson]

I would like to have the user choose a
selection in the first field and have the second field
automatically populate.

This sounds like a Design Problem. There should not be any need for
"copying" two fields from one table to another: you should be using a
proper foreign key/ relationship to do the linking.

Check out the help pages or a simple book on Relational design.

HTH


Tim F