Hanna Philippi
15-Nov-2005, 10:23 AM
hello all,
I have a order header database where the shipper id is linked to a shipper
database.
In the web look up everything works great and I get the value back from the
pop up list.
the problem is that when it have a problem saving the record in the order
entry complaining about
Could not save changes
Please enter a valid record id
"Customer#" field in "SHIPPER" data file
what is missing?
<Form action="OrderDetails.asp" method="POST" name="dateform"
onsubmit="SetChangedStates(this)" >
<% ' You MUST have a hidden recnum field for each DDO in your WBO %>
<input type="hidden" size="15" name="Orderhea__Recnum"
Value="<%=oOrderDetails.DDValue("Orderhea.Recnum")%>" >
<input type="hidden" size="15" name="Orderdtl__Recnum"
Value="<%=oOrderDetails.DDValue("Orderdtl.Recnum")%>" >
<input type="hidden" size="15" name="Invt__Recnum"
Value="<%=oOrderDetails.DDValue("Invt.Recnum")%>" >
<input type="hidden" size="15" name="Shipper__Recnum"
Value="<%=oOrderDetails.DDValue("shipper.Recnum")%>" >
<p>
<p>
<p>
<input type="submit" name="save" value="Save">
<input type="submit" name="delete" value="Delete">
<input type="submit" name="clear" value="Clear">
Find
<input type="submit" name="findfirst" value="<<">
<input type="submit" name="findprev" value="<">
<input type="submit" name="find" value="=">
<input type="submit" name="findnext" value=">">
<input type="submit" name="findlast" value=">>">
or
<input type="submit" name="RunReport" value="List">
</p>
<table border="1" cellpading="6" cellspacing="1" Class="EntryTable"
width="100%">
<tr>
<td Class="Label" width="100"><font size="2" face="Arial">Document
Number</font></td>
<td Class="Data"><input type="text" size="6" title=""
name="Orderhea__Order_Number"
value="<%=oOrderDetails.DDValue("Orderhea.Order_Number") %>" ></td>
<td class="Label" width="200" colspan="2"><font size="2"
face="Arial">Bill Customs Charges To</td>
</tr>
<tr>
<td class="Label" width="100" ><font size="2"
face="Arial">Shipper/Exporter</font></td>
<td class="data"><input type="text" size="10" title=""
name="Orderhea__Shipper_Number"
value="<%=oOrderDetails.DDValue("shipper.customer#") %>" >
I have a order header database where the shipper id is linked to a shipper
database.
In the web look up everything works great and I get the value back from the
pop up list.
the problem is that when it have a problem saving the record in the order
entry complaining about
Could not save changes
Please enter a valid record id
"Customer#" field in "SHIPPER" data file
what is missing?
<Form action="OrderDetails.asp" method="POST" name="dateform"
onsubmit="SetChangedStates(this)" >
<% ' You MUST have a hidden recnum field for each DDO in your WBO %>
<input type="hidden" size="15" name="Orderhea__Recnum"
Value="<%=oOrderDetails.DDValue("Orderhea.Recnum")%>" >
<input type="hidden" size="15" name="Orderdtl__Recnum"
Value="<%=oOrderDetails.DDValue("Orderdtl.Recnum")%>" >
<input type="hidden" size="15" name="Invt__Recnum"
Value="<%=oOrderDetails.DDValue("Invt.Recnum")%>" >
<input type="hidden" size="15" name="Shipper__Recnum"
Value="<%=oOrderDetails.DDValue("shipper.Recnum")%>" >
<p>
<p>
<p>
<input type="submit" name="save" value="Save">
<input type="submit" name="delete" value="Delete">
<input type="submit" name="clear" value="Clear">
Find
<input type="submit" name="findfirst" value="<<">
<input type="submit" name="findprev" value="<">
<input type="submit" name="find" value="=">
<input type="submit" name="findnext" value=">">
<input type="submit" name="findlast" value=">>">
or
<input type="submit" name="RunReport" value="List">
</p>
<table border="1" cellpading="6" cellspacing="1" Class="EntryTable"
width="100%">
<tr>
<td Class="Label" width="100"><font size="2" face="Arial">Document
Number</font></td>
<td Class="Data"><input type="text" size="6" title=""
name="Orderhea__Order_Number"
value="<%=oOrderDetails.DDValue("Orderhea.Order_Number") %>" ></td>
<td class="Label" width="200" colspan="2"><font size="2"
face="Arial">Bill Customs Charges To</td>
</tr>
<tr>
<td class="Label" width="100" ><font size="2"
face="Arial">Shipper/Exporter</font></td>
<td class="data"><input type="text" size="10" title=""
name="Orderhea__Shipper_Number"
value="<%=oOrderDetails.DDValue("shipper.customer#") %>" >