Auto Fill table field

[maabbas]

Hi guys,

I have been away for Access for a long time and having issue with making a query. I have 3 tables. "tablEmployee" has employee ID, first name, last name and sizer ID. "tblproduct" has product ID, Description and rate. I made a new table called tbldata which has date, product code, product description, product rate,employee id, employee sizer id, and lbs. I want a query when I enter the product id in tbldata, query auto fill the product description and rate. also same as employee.

Any help will be greatly appreciated.

 

[maabbas]

Any help guys

 

[pr2-eugin]

Could you show some sample data in the tables and also show what should be happening by the result of this query?

 

[maabbas]

Could you show some sample data in the tables and also show what should be happening by the result of this query?

Thanks for reply, the data in tblemployee are as follow

Employee ID Last Name First Name Sizer ID
123 Smith John 1

tblProduct

Product Code Description Rate
5011 Chunks 0.10

and tbldata

Date Product Code Product Description Sizer ID Last Name First Name Lbs
05/01 5011 1


I want to make form from tbldata when user enter product code and sizer id the product desctiption and last and first name auto fill. Like we use Vlookup Function in XL

Thanks