Please Help maybe dlookup

  • Thread starter Thread starter Philip
  • Start date Start date
P

Philip

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
 
Phillip,

In good database design, you only want that ProductNumber
stored in the table. You can then tie in the two tables with
a query and pull in the ProductDescription for display
purposes. You can then base your form on the query (as well
as reports) and the ProductDescription can be displayed with
ease although you will never actually enter it anywhere.

Gary Miller
Sisters, OR
 
Back
Top