PDA

View Full Version : How to retreive recnum value from a lookup to a form ?



Barry Dopp
2-Oct-2007, 05:17 PM
I am trying to retrieve the record number of Client from a lookup list to a
form
It says unknown field

I can return all other fields from this lookup except the Recnum.
How to I get the Recnum value?

<td class="Data">
<%=oUser.DDValue("Client.RecNum",DDFORM)%>
<input class="LookupButton" type="button" title="List of all records"
tabindex="-1" vdfControlType="lookupdialog" vdfLookupTable="Client"
vdfWebObject="oClient" vdfLookupFields="Client__ClientId,
Client__ClientName" />
</td>


Thanks B Dopp

Harm Wibier
3-Oct-2007, 01:58 AM
Hello Barry,

The AJAX Library has no support for recnum fields. You can display the
recnum on the client by adding an User Data field to the form (a field
without __ in its name or data binding) and fill in the WO by augmenting the
OnAjaxRequestEnd event and calling the SetAjaxRequestUserData method.

--
Regards,


Harm Wibier
Data Access Europe B.V.
http://www.dataaccess.nl/


"Barry Dopp" <Support@Enterprisetime.ca> wrote in message
news:jjJZEIUBIHA.752@dacmail.dataaccess.com...
>I am trying to retrieve the record number of Client from a lookup list to a
>form
> It says unknown field
>
> I can return all other fields from this lookup except the Recnum.
> How to I get the Recnum value?
>
> <td class="Data">
> <%=oUser.DDValue("Client.RecNum",DDFORM)%>
> <input class="LookupButton" type="button" title="List of all records"
> tabindex="-1" vdfControlType="lookupdialog" vdfLookupTable="Client"
> vdfWebObject="oClient" vdfLookupFields="Client__ClientId,
> Client__ClientName" />
> </td>
>
>
> Thanks B Dopp
>

Bob Worsley
3-Oct-2007, 07:06 AM
Barry, you might want to read up on RecId functionality, it performs the
same general purpose as Recnum, and is easily implemented in WebApps.
Bob

"Barry Dopp" <Support@Enterprisetime.ca> wrote in message
news:jjJZEIUBIHA.752@dacmail.dataaccess.com...
> I am trying to retrieve the record number of Client from a lookup list to
a
> form
> It says unknown field
>
> I can return all other fields from this lookup except the Recnum.
> How to I get the Recnum value?
>
> <td class="Data">
> <%=oUser.DDValue("Client.RecNum",DDFORM)%>
> <input class="LookupButton" type="button" title="List of all records"
> tabindex="-1" vdfControlType="lookupdialog" vdfLookupTable="Client"
> vdfWebObject="oClient" vdfLookupFields="Client__ClientId,
> Client__ClientName" />
> </td>
>
>
> Thanks B Dopp
>
>
>