<div>
and they are both number fields. &nbsp;
</div>


<div>
Is &nbsp;tblLetterOfCredit.Guarante<wbr />eCode involved in any indexes that may be defined as unique?
</div>


Is  tblLetterOfCredit.GuaranteeCode involved in any indexes that may be defined as unique?

<div>
Specifically check for duplicate [Import-CSM].[Reference Number] &nbsp;or tblLetterOfCredit.LCNo. &nbsp;If either of these tables contain duplicates the the update will fail since there is more than one match in the inner join. 
</div>


Specifically check for duplicate [Import-CSM].[Reference Number]  or tblLetterOfCredit.LCNo.  If either of these tables contain duplicates the the update will fail since there is more than one match in the inner join.

<div>
darn duplicates. &nbsp; thx
</div>


<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I have the below SQL.<br />
I need to update blLetterOfCredit.[Guarante<wbr />eCode] &nbsp;to the value in Import-csm.[Guarantor Code] <br />
I think I have it right but it gives me an error that basically says it cant update due to key violations. <br />
<br />
Import-csm.[Guarantor Code] and tblLetterOfCredit.Guarante<wbr />eCode are both the same property in the tables as Double, General Number and Indexed No duplicates. &nbsp;I initially had Import-csm.[Guarantor Code] as a Primary Key thinking that might be the issue but I removed it and still have the same error. &nbsp;<br />
<br />
What do you think could be the cause of this error? &nbsp;<br />
<br />
here is the SQL:<br />
UPDATE [Import-CSM] INNER JOIN tblLetterOfCredit ON [Import-CSM].[Reference Number] = tblLetterOfCredit.LCNo SET tblLetterOfCredit.Guarante<wbr />eCode = [Guarantor Code];<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2011/10_w44/517672/untitled.JPG" target="_blank" title="Qry Design (29 KB)"><img alt="Qry Design" class="file-block lazyload" style="max-width: 389px;" data-src="https://filedb.experts-exchange.com/incoming/2011/10_w44/517672/untitled.JPG" /></a> <a href="https://filedb.experts-exchange.com/incoming/2011/10_w44/517675/untitled.JPG" target="_blank" title="Error (19 KB)"><img alt="Error" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2011/10_w44/800_517675/untitled.JPG" /></a>
</div>
</div>


untitled.JPG

Experts,

I have the below SQL.
I need to update blLetterOfCredit.[GuaranteeCode]  to the value in Import-csm.[Guarantor Code] 
I think I have it right but it gives me an error that basically says it cant update due to key violations. 

Import-csm.[Guarantor Code] and tblLetterOfCredit.GuaranteeCode are both the same property in the tables as Double, General Number and Indexed No duplicates.  I initially had Import-csm.[Guarantor Code] as a Primary Key thinking that might be the issue but I removed it and still have the same error.  

What do you think could be the cause of this error?  

here is the SQL:
UPDATE [Import-CSM] INNER JOIN tblLetterOfCredit ON [Import-CSM].[Reference Number] = tblLetterOfCredit.LCNo SET tblLetterOfCredit.GuaranteeCode = [Guarantor Code];
  

Update query help

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.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.