Can I do this with a macro

[Phil]

I am having a hard time getting this.
I have a table called tbStyles with two fields a
ProductNumber and ProductDescription field.

I have another table called tbPrices that I have to enter
the ProductNumber and I want the ProductDescrption to
fill in automatically.

I would also like to do this on a form.

I cant make any sense of MS help

Thanks so much

 

[Ken Snell]

You can't do this directly in a table. You must use a form with controls
that are bound to the different table fields (and the table fields must be
in the form's record source).

 

[Van T. Dinh]

Beware: it sounds like you are storing redundant data in tblPrice.

If you store the ProductNumber in the tblPrice, you should NOT store the
ProductDescription in tblPrice because from the stored value of
ProductNumber, you can derive the relevant ProductDescription from the
tblStyles.

Ken already advised regarding showing on Form.

HTH
Van T. Dinh
MVP (Access)