automating an entry

  • Thread starter Thread starter briank
  • Start date Start date
B

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?
 
I would like to have the user choose a
selection in the first field and have the second field
automatically populate.
Click to expand...

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
 
Back
Top