Auto Look Up Dumb Question

[Philip]

I am having a hard time getting this.
I have a table with two fields a product number and a
product description field.

I have another table that I have to enter the number and
I want the product descrption to fill in automatically.

I would alsoike to do this on a form.

I cant make any sense of MS help

Thanks so much

 

[Tim Ferguson]

I have another table that I have to enter the number and
I want the product description to fill in automatically.

No: in the other table, you enter just the number, so that the description
can be looked up whenever it is needed. To see everything in one place, you
create a query with the two tables joined together.

I would also like to do this on a form.

Yes: that is the best way. If you want to save the effort of creating the
query, you can make an unbound textbox and set its controlsource to
something like:

=DLookup("Description", "Products", "Catnumber=" & Me!txtProductID)

so that it will update itself whenever the ProductID changes.


Hope that helps


Tim F