Please Help

[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
..

 

[TC]

Phil, you won't learn Access easily just by using the online help. I
recommend you find a book on learning Access. This is not meant to be a
smart comment. It is a serious suggestion on how to get started effectively.

HTH,
TC

 

[John Vinson]

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.

No. You don't want the product description to fill in automatically!
It should NOT EXIST in tbPrices.

You're using a relational database; a fundamental principle of
relational databases is that you don't store data redundantly. Store
the description ONCE; if you need to see the description together with
a price, use a Query to look it up, or use a Combo Box to display the
description while storing the ProductNumber.