<div>
Why don't you join the two tables by LicenceNumberFK &nbsp;and ArmPK?
</div>


Why don't you join the two tables by LicenceNumberFK  and ArmPK?

Developer

Murray Brown

<div>
Join the tables on ArmPK and update t_arms.licenceNumberFK = t_arms2.licenceNumberFK<br />
<br />

<pre><code id="code-20-43015413-1">UPDATE t_arms INNER JOIN t_arms ON t_arms2.armpk= t_arms.armpk SET t_arms.licenceNumberFK = t_arms2.licenceNumberFK </code></pre>
<br />
assuming the armpk will identify your records.<br />
perhaps ryb this on your test system first to test the result
</div>


Join the tables on ArmPK and update t_arms.licenceNumberFK = t_arms2.licenceNumberFK



UPDATE t_arms INNER JOIN t_arms ON t_arms2.armpk= t_arms.armpk SET t_arms.licenceNumberFK = t_arms2.licenceNumberFK 


assuming the armpk will identify your records.
perhaps ryb this on your test system first to test the result

<div>
In your other thread on this topic, you said that you were simply trying to display the LicenseNumber on a second form. &nbsp;You said you weren't storing the data twice. &nbsp;I guess you didn't mean that.
</div>


In your other thread on this topic, you said that you were simply trying to display the LicenseNumber on a second form.  You said you weren't storing the data twice.  I guess you didn't mean that.

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have the two Access tables shown in the image. I want to update the LicenceNumberFK field using the correct values in the second table that I imported from Excel t_Arms2. I want to do this by looking up the LicenceNumberFK field in t_Arms2 using the ArmPK field<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2020/01_w04/1441609/Image1.JPG" target="_blank" title="1 (43 KB)"><img alt="1" class="file-block lazyload" style="max-width: 508px;" data-src="https://filedb.experts-exchange.com/incoming/2020/01_w04/1441609/Image1.JPG" /></a>
</div>
</div>


Image1.JPG

Hi

I have the two Access tables shown in the image. I want to update the LicenceNumberFK field using the correct values in the second table that I imported from Excel t_Arms2. I want to do this by looking up the LicenceNumberFK field in t_Arms2 using the ArmPK field



Access update a column using DLookup or something similar

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.