Auto Populate Field Based on other fields table access

[pencheng]

I made a lookup in the field A (Table 2) in order to select the data store in another table (Table 1). However, how can I create an autofilling for field B based on the value in field A and referring the data in Table 2. Maybe the question cannot be elaborated, I have attached a sample of my situation.

[pbaldy]

In a form:

http://www.baldyweb.com/Autofill.htm

[pencheng]

How should I format the Number field to retrieve the right column data (789) from other table? Or how can I show data 789 on report view?

[pbaldy]

For a report, you'd base it on a query that joined the 2 tables, enabling you to return fields from both.