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.

[TABLE="width: 313"]
<tbody>[TR]
[TD]ID No
[/TD]
[TD]Product Description
[/TD]
[TD]Qty
[/TD]
[TD]Rate
[/TD]
[/TR]
[TR]
[TD]25
[/TD]
[TD]ID Card
[/TD]
[TD]100
[/TD]
[TD]70
[/TD]
[/TR]
[TR]
[TD]26
[/TD]
[TD]ID Card Rope
[/TD]
[TD]100
[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD]27
[/TD]
[TD]ID Card Holder
[/TD]
[TD]100
[/TD]
[TD]10
[/TD]
[/TR]
</tbody>[/TABLE]

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