calculated field in Access 2010 with lookup function

[infoexcel]

I need Macro or any other functions for Access 2010. As entering ID number in Table the next column should bring the related values. The following details in a table.

ID No	Product Description	Qty	Rate
25	ID Card	100	70
26	ID Card Rope	100	10
27	ID Card Holder	100	10

<tbody>
</tbody>

I need another table, while entering ID No alone, Calculated field in each column should bring the value of "Product Description" "Qty" "Rate" . Kindly suggest any possible options to work in Access 2010 via Macro or any other functions.

 

[alansidman]

Not sure I understand exactly what you are looking for. It sounds like this may be the answer

Autofill