Hi Max,
All of the customers have a Uniq number witch is given from in the old program, so I assume it is not created with PHP uniqid() function. When I imported it into phpmyadmin it did not gave me a error. Klanten_id is a UNIQUE KEY (klanten is consumers in dutch).
- So if you say that I have to change the ID's to a 13 digit number with or without some letters I can do that, but I don't think that it wil work because i just found out that some of the new consumers (with have a nuBuilder Uniq ID) have the same problem.
- What do you mean with PK and FK fields? al the ID fiels are varchar(15) NOT NULL. Like the sample_nufinancial module.
With Firebug I see this for the lookup field
Code: Select all
<td class="selected" style="text-align:left">
<input id="koop_klanten_id" type="hidden" value="106015396" name="koop_klanten_id">
<input id="codekoop_klanten_id" class="lookupcode" onclick="edit_lookup('151629be0a29d0', 'koop_klanten_id')" ondblclick="if(nuShiftKey){nuMoveObject(this.id.substring(4), 0,0);return;};nuControlKey=true;openIBrowse('151629ec00930e', '', '', '153298b8b1a6cf', '1532991f197417')" accept="151629ec00930e" onfocus="nuSetRow('');" onchange=";" style="width:144px;" value="Aalbersberg" name="codekoop_klanten_id">
<img id="luup_koop_klanten_id" class="lubutton" onclick=" nuSetRow(''); nuControlKey=true;openIBrowse('151629ec00930e', '', '', '153298b8b1a6cf', '1532991f197417') " onmousedown=" this.src='ludown.png'" onmouseout=" this.src='luup.png' " onmouseup=" this.src='luup.png' " style="vertical-align:text-bottom" alt="Lookup" src="luup.png">
<input id="descriptionkoop_klanten_id" type="hidden" tabindex="10000" readonly="readonly" style="width:0px;" value="" name="descriptionkoop_klanten_id">
</td>
And this for de the field that has to be updated.
Code: Select all
<td class="selected" style="text-align:left;white-space: nowrap;">
<input id="koop_klant_naam" class="readonly" type="text" tabindex="10000" readonly="readonly" ondblclick="if(nuShiftKey){nuMoveObject(this.id, 0,0);return;};" onfocus="nuSetRow('');" onchange="uDB(this,'text');" style="width:240px;text-align:left;vertical-align:top;" name="koop_klant_naam">
</td>
I don't see any wrong things, I hope you see something.
Thank allready for helping me.
Jeroen