Autofill field from linked table

[martyn]

In table weekly- field names are jobno, companyno, companyna and etc. In table Job - weekly can find the jobno field, but I also want it to find the companyno from the same record that the jobno comes from. Then I want it to take that company number and find it in the related customer table and put that company name in the weekly table. <br>
<br>
The tables job, customer, and weekly are related. (joined)?<br>
I want it to drop the information from the job and customer table into the weekly table. Kind of a look-up funtion that will become the data for that particular field.

 

[DougP]

So you almost there.<br>
I start by creating a query<br>
Add all 3 of your tables.<br>
Click on the &quot;companyno&quot; field in the &quot;weekly&quot; table and drag toward the &quot;companyno&quot; field in the customer table.<br>
Do the same for the third table so it has the correct field link.<br>
Now to add fields to your query drag &quot;jobno&quot;, &quot;companyno&quot;, &quot;companyna&quot; from the table down to the grid below.<br>
<br>
Add just a few fields from each table to get it working.<br>
<br>
In the &quot;Criteria&quot; field for Job number<br>
Key in a valid job number.<br>
<br>
Then click the RED Exclmation mark at the top to run it.<br>
It should bring up that job and the correct customer etc.<br>
<br>
OK<br>
<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>