PDA

View Full Version : list for a foreign key



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="&lt;&lt;">
<input type="submit" name="findprev" value="&lt;">
<input type="submit" name="find" value="=">
<input type="submit" name="findnext" value="&gt;">
<input type="submit" name="findlast" value="&gt;&gt;">
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#") %>" >

Evertjan Dondergoor
16-Nov-2005, 03:54 AM
Hello Hanna,

Bot sure if it is the caus of your problem but this line:

<input type="text" size="10" title="" name="Orderhea__Shipper_Number"
value="<%=oOrderDetails.DDValue("shipper.customer#") %>" >

is quite odd. The fieldname is OrderHea__Shiper_number but you get the value shipper.customer# and does not make sense. For reasons
like this I normally use:
<% =oOrderDetails.ddValue("Shipper.customer#", DDFORM) %>

I also find this syntax easier to read.

Regards,
Evertjan


"Hanna Philippi" <hphilippi@icecorp.ca> wrote in message news:6I38Iif6FHA.3660@dacmail.dataaccess.com...
> 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="&lt;&lt;">
> <input type="submit" name="findprev" value="&lt;">
> <input type="submit" name="find" value="=">
> <input type="submit" name="findnext" value="&gt;">
> <input type="submit" name="findlast" value="&gt;&gt;">
> 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#") %>" >
>
>